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

Calculate Filtered Cells Only 7
need help on either doing a loop and counting specific values orusing subtotal function 2
Formula to count text string in column cells of filtered rows 3
How can I count items in a filtered list? 40
VBA: How can I use a string variable as autofilter criteria? 4
how do i count amount of data in a filtered list? 4
How do I count the number of filtered rows 2
How do I count the number of filtered rows 3

Top