software

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: www.excelforum.com/member.php...oamp;userid=33123
View this thread: www.excelforum.com/showthread...hreadid=543404You 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)

quot;luvmath03quot; gt; wrote
in message ...
gt;
gt; I would like to be able to enter numbers into ranges.
gt;
gt; Homework grades are in d4, f4, h4....
gt; Test/Quiz grades are in e4, g4, i4....
gt;
gt; then be able to perform math operations on these.....
gt;
gt; I have tried to give a range name but it does not seem to work.
gt;
gt; I have to split each like this because I have dates that associate with
gt; these.
gt;
gt; For example.....d4 and e4 are on 15 oct, 16 oct is f4 and g4.
gt;
gt; Can someone help?
gt;
gt;
gt; --
gt; luvmath03
gt; ------------------------------------------------------------------------
gt; luvmath03's Profile:
www.excelforum.com/member.php...oamp;userid=33123
gt; View this thread: www.excelforum.com/showthread...hreadid=543404
gt;

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: www.excelforum.com/member.php...oamp;userid=34531
View this thread: www.excelforum.com/showthread...hreadid=543404
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: www.excelforum.com/member.php...oamp;userid=34531
View this thread: www.excelforum.com/showthread...hreadid=543404You 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 gt; Name gt; 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 gt; Name gt; 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
quot;luvmath03quot; wrote:

gt;
gt; I would like to be able to enter numbers into ranges.
gt;
gt; Homework grades are in d4, f4, h4....
gt; Test/Quiz grades are in e4, g4, i4....
gt;
gt; then be able to perform math operations on these.....
gt;
gt; I have tried to give a range name but it does not seem to work.
gt;
gt; I have to split each like this because I have dates that associate with
gt; these.
gt;
gt; For example.....d4 and e4 are on 15 oct, 16 oct is f4 and g4.
gt;
gt; Can someone help?
gt;
gt;
gt; --
gt; luvmath03
gt; ------------------------------------------------------------------------
gt; luvmath03's Profile: www.excelforum.com/member.php...oamp;userid=33123
gt; View this thread: www.excelforum.com/showthread...hreadid=543404
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=33123
View this thread: www.excelforum.com/showthread...hreadid=543404Try selecting the range as we've discussed, then instead of doing the Insert
gt; Name thing, just go to the quot;NameBoxquot; and type in the new RangeName like
Bob suggested..........maybe it will quot;takequot; that way...

hth
Vaya con Dios,
Chuck, CABGx3
quot;luvmath03quot; wrote:

gt;
gt; I am doing exactly that CLR.....
gt;
gt; I select each cell by holding the cntrl key and left clicking on d4,
gt; f4, h4, ...,cf4, cg4. After that, I go to insert, name, define. I get
gt; the following error.
gt;
gt; Your formula contains an invalid external reference to a worksheet. It
gt; says to verify the path, workbook, range name, or cell reference are
gt; correct then to try again.
gt;
gt; When I click in the Define name box and look at the refers to
gt; box.....it stops at $X$4 does not have $AB$4 or anything.
gt;
gt; william
gt;
gt;
gt; --
gt; luvmath03
gt; ------------------------------------------------------------------------
gt; luvmath03's Profile: www.excelforum.com/member.php...oamp;userid=33123
gt; View this thread: www.excelforum.com/showthread...hreadid=543404
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=33123
View this thread: www.excelforum.com/showthread...hreadid=543404There 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, CABGx3quot;luvmath03quot; gt; wrote
in message ...
gt;
gt; Have done exactly that.
gt;
gt; It seems to work properly....but if I open the names dialog and click
gt; on the new created name......then click OK....I get the same error as
gt; stated in previous message.
gt;
gt; is there a certain way that we must reference the AA or CB cells?
gt;
gt; William
gt;
gt;
gt; --
gt; luvmath03
gt; ------------------------------------------------------------------------
gt; luvmath03's Profile:
www.excelforum.com/member.php...oamp;userid=33123
gt; View this thread: www.excelforum.com/showthread...hreadid=543404
gt;