How do I 'count' the number of entrances in filtered cells?

M

Mike Prentice

I am producing a speadsheet containing text date which I have filtered using
the auto filter box. The raw date is a list of different categories of text
which I use the filter to seperate into the appropriate category. Is there a
way for me to count the number of entries under the filtered categories
without doing it manually? when I use the COUNTA command it counts the total
number of entrances in the raw data, not the number in the filtered list.

Many thanks

Mike
 
P

Peo Sjoblom

=SUBTOTAL(3,Full_Range)


so if your table/list is A2:A500

=SUBTOTAL(3,A2:A500)

will count visible filtered cell


in Excel 2003 onwards you can also use


=SUBTOTAL(103,A2:A500)


which will count only visible cells either filtered or hidden



--


Regards,


Peo Sjoblom
 

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

need help on either doing a loop and counting specific values orusing subtotal function 2
How to count the numbers in a Word document? 0
Count Number of Rows 2
Count Advanced Filtered Rows 3
Calculate Filtered Cells Only 7
Count Number of Unique Cells That Don't Have Certain Characters 0
Formula to count text string in column cells of filtered rows 3
Count Number of Visible Rows in Filtered View 2

Top