View Single Post
 
Old 05-12-2018, 08:56 AM
excelino excelino is offline Windows 10 Office 2000
Novice
 
Join Date: May 2018
Posts: 2
excelino is on a distinguished road
Unhappy 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?
Reply With Quote