range names

  • Thread starter Thread starter luvmath03
  • Start date Start date
L

luvmath03

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?
 
You can do that.

In Excel, select all those cells, then type the name in the Names box (left
of the formula bar).

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Hi:

I believe the format you are looking at are reserved for cell locations
in the excel scheme of things.....you might try something line C_3 or
A_5

plettieri
 
Hi:

I may have misunderstood your question... I thought you were tring to
name your ranges a1, a4, c4 ..etc..

my appoligies,

plettieri
 
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
 
I am doing exactly that CLR.....

I select each cell by holding the cntrl key and left clicking on d4
f4, h4, ...,cf4, cg4. After that, I go to insert, name, define. I ge
the following error.

Your formula contains an invalid external reference to a worksheet. I
says to verify the path, workbook, range name, or cell reference ar
correct then to try again.

When I click in the Define name box and look at the refers t
box.....it stops at $X$4 does not have $AB$4 or anything.

willia
 
Try selecting the range as we've discussed, then instead of doing the Insert
Name thing, just go to the "NameBox" and type in the new RangeName like
Click to expand...
Bob suggested..........maybe it will "take" that way...

hth
Vaya con Dios,
Chuck, CABGx3
 
Have done exactly that.

It seems to work properly....but if I open the names dialog and click
on the new created name......then click OK....I get the same error as
stated in previous message.

is there a certain way that we must reference the AA or CB cells?

William
 
There may be a limit to the number of segments that a non-contiguous range
can contain.........how many are you trying to put in?

Vaya con Dios,
Chuck, CABGx3
 
Back
Top