View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dennis dennis is offline
external usenet poster
 
Posts: 202
Default 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