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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUBTOTAL 2
subtotal filter with growing range 2
Getting Text data using the Data - Subtotal feature 1
subtotal not showing after filtering list 1
SUBTOTAL not refreshing when using advanced filter 2
To show the sunbtotal in retrieved rows 8
Recalculating Subtotals 2
How can I automatically print subtotal on last row of every page? 3

Back
Top