counting filtered rows
 

I have a column of data that I filter according to user
input. I need to count the number of items in the filter.
For example, I filter column A for "XYZ" and discover
that there are 11 items in the filter. I can count them
visually but I need to count them programmatically.

How can I do that? If I try to run Countif(), I get an
error message.

Gmet

counting filtered rows
 

Hi
see:
http://www.contextures.com/xlautofilter03.html#Count

--
Regards
Frank Kabel
Frankfurt, Germany


gmet wrote:
I have a column of data that I filter according to user
input. I need to count the number of items in the filter.
For example, I filter column A for "XYZ" and discover
that there are 11 items in the filter. I can count them
visually but I need to count them programmatically.

How can I do that? If I try to run Countif(), I get an
error message.

Gmet

counting filtered rows
 

Have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software

"gmet" wrote in message
...
I have a column of data that I filter according to user
input. I need to count the number of items in the filter.
For example, I filter column A for "XYZ" and discover
that there are 11 items in the filter. I can count them
visually but I need to count them programmatically.

How can I do that? If I try to run Countif(), I get an
error message.

Gmet