=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.