counting filtered rows

G

gmet

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
 
Top