Range Naming, dimensioning

[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

 

[Max]

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.

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

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