Hi,

If I have COUNT(A1:A100) with a total in the row #101 and when a user insert
a row between the 98 and 99 rows the function will be COUNT(A1:A101) and the
total will be in the row #102, which is fine - the row has been added into
the function.

But, when a user adding a row between the total row (101) and the previous
row (100), the total will be in the row 102 but the function will remain the
same and the one row will be missing from the calculation.

How could I resolve it and give the user the flexibility to add a row the
total row?

Thanks