Diappearing rows?

P

Paul H

I have a 2,345 row spreadsheet using a filter near the top and at the bottom
I have a =SUBTOTAL(9,F6:F2345) equation. When I filter to a single account
(one account with twelve months showing) the subtotal cell at the bottom is
not seen. The subtotal is on row 2346. Why does this happin?
 
G

Gary''s Student

Perhaps just that the filtering is including the row with the =SUBTOTAL() in it

To verify this, move the row with the subtotals to above row #6
 
Top