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

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

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

=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

"Mike Prentice" <Mike wrote in message
...
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

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

Lookup the SUBTOTAL worksheet function in help

"Mike Prentice" wrote:

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