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

=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

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