Diappearing rows?

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?
 
G

Guest

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 refreshing when using advanced filter 2
subtotal not showing after filtering list 1
To show the sunbtotal in retrieved rows 8
Subtotal data excluding negitive numbers. 3
Counting number of days excluding certain values 3

Top