| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print range names and how know if have too many? | Excel Worksheet Functions | |||
| not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
| Range Names | Excel Worksheet Functions | |||
| Excel Range Names | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Linear Mode
