SUBTOTAL FUNCTION PROBLEM when add a new line on top
Hello,
I use at cell C1 this function
=SUBTOTAL(9;(C2:C12))
If I add a line at the top and the data from C2 qoes to C3 ecc the new data at C2 it's not be calculate by the function.
I'm not sure if I explain well, because my English it's really bad, but I want to keep the function ordel also when I add a new line so from
=SUBTOTAL(9;(C2:C12))
-----------------------------> NEW LINE C2
=SUBTOTAL(9;(C2:C13))
ecc
is this possible?
|