Range Naming, dimensioning

  • Thread starter Thread starter contiw
  • Start date Start date
C

contiw

=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 modifie
accordingly, but if I add cells in the range the formulae do no
recognize the change

Thanks for helping a noob
 
Not sure why there's no response as yet to this posting ..

Just hazarding some thoughts.
I don't know/don't have xl2007 so I'm not able to test this.
=SUMIFS(Col_1,C9:C1494,1)
I get #VALUE error.
Click to expand...

1. Maybe you need to array-enter the formula?
Try pressing CTRL+SHIFT+ENTER

2. Maybe your named range Col_1 has somehow gone out of sync (in size) with
C9:C1494?
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
Click to expand...

If I insert rows above the last row in the col range, it works fine

Hang around awhile for better answers from responders versed in xl2007

---
 
Back
Top