| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Range Naming, dimensioning
=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 a noob. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming a range | Excel Discussion (Misc queries) | |||
| Range naming | Excel Discussion (Misc queries) | |||
| Naming a range during macro execution | Excel Discussion (Misc queries) | |||
| Naming Sheets using a range in another worksheet | Excel Worksheet Functions | |||
| Naming a range | Excel Discussion (Misc queries) | |||
Threaded Mode
