You can create non-contiguious ranges by holding down the Ctrl key and
individually selecting the cells in one row, like D4, F4, and H4, etc, then
do Insert Name Define, and type something descriptive like TommyHomework
in the name window.....then hold down Ctrl and select E4, G4, and I4, etc etc
and then do Insert Name Define and enter the name TommyQuiz......
Then at the right end of row 4, put these formulas in two adjacent cells
=SUM(TommyHomework)
=SUM(TommyQuiz)
or =AVERAGE(TommyHomework), etc etc.........

hth
Vaya con Dios,
Chuck, CABGx3



"luvmath03" wrote:


I would like to be able to enter numbers into ranges.

Homework grades are in d4, f4, h4....
Test/Quiz grades are in e4, g4, i4....

then be able to perform math operations on these.....

I have tried to give a range name but it does not seem to work.

I have to split each like this because I have dates that associate with
these.

For example.....d4 and e4 are on 15 oct, 16 oct is f4 and g4.

Can someone help?


--
luvmath03
------------------------------------------------------------------------
luvmath03's Profile: http://www.excelforum.com/member.php...o&userid=33123
View this thread: http://www.excelforum.com/showthread...hreadid=543404