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
|