|
|
#1
08-01-2007, 10:25 AM
|
|||
|
|||
Range names and length stuff. Please help-a-noob.
=SUMIFS(E9:E1494,C9:C1494,1)
This formula works ok. If I rename range E9:E1494 as "Col_1" and change the formula to =SUMIFS(Col_1,C9:C1494,1) I get #VALUE error. The range is formatted as number. Also ... If I delete some cells in a range, referring formulae are modified accordingly, but if I add cells in the range the formulae do not recognize the change Thanks for helping. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to set the same length for different lines | myword29 | Word | 0 | 09-28-2007 08:12 PM |
| A Noob Question | Techknology | Outlook | 0 | 11-30-2006 07:47 AM |
| Two Different Names in the Same File | kathy carson | Outlook | 0 | 02-14-2006 01:02 PM |
 Mysterious "Subscript out of range" error
|
rnstewart | Excel | 4 | 12-29-2005 01:04 PM |
Threaded Mode