#1
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2016 Excel Subtotal Function Changed | CindyPauls | Excel | 0 | 08-31-2017 11:44 AM |
Problem with Value function | misokol | Excel | 3 | 01-11-2017 08:59 AM |
Problem with function | PRA007 | Word VBA | 2 | 01-13-2016 01:11 AM |
Function problem | li roy | Excel | 2 | 02-18-2012 02:44 AM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |