If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|