Count in a filtered sheet

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

I want to count the number of rows returned following an
advanced filter. I cannot seem to find a way to do this,
it always wants to count ALL the rows. Any tips?
 
Hi
have a look at the SUBTOTAL function. e.g.
=SUBTOTAL(3,A1:A1000)
 
You must log in or register to reply here.

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

SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
COUNT rows on external sheet if between date range 3
need help on either doing a loop and counting specific values orusing subtotal function 2
Count Advanced Filtered Rows 3
count unique values in a filtered range 2
count similar text with using filters 1
Count rows after filter 2
COUNT returning 0? 4

Back
Top