range names
 

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

range names
 

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)

"luvmath03" wrote
in message ...

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

range names
 

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


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

range names
 

Hi:

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

my appoligies,

plettieri


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

range names
 

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

range names
 

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 get
the following error.

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

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

william


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

range names
 

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
Bob suggested..........maybe it will "take" that way...

hth
Vaya con Dios,
Chuck, CABGx3



"luvmath03" wrote:


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 get
the following error.

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

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

william


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

range names
 

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


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

range names
 

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


"luvmath03" wrote
in message ...

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


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