Diappearing rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top