ExcelBanter - Diappearing rows?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Diappearing rows? (https://www.excelbanter.com/excel-discussion-misc-queries/131867-diappearing-rows.html)

Paul H

Diappearing rows?

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?

Gary''s Student

Diappearing rows?

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
--
Gary's Student
gsnu200707

"Paul H" wrote:

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?

All times are GMT +1. The time now is 07:30 AM.