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