So, my previous reply mixed in from a different question... der. But your
reply did help me count ocurrences on my filter.

Thanks!


"Domenic" wrote:

Assuming that you'd like to count the number of cells in Column B that
meet the criteria, in a filtered list, try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B100,ROW(B2:B100)-ROW(B2),0,1)),--(B2:B1
00="Criteria"))

If the criteria is a numerical value, remove the quotes.

Hope this helps!

In article ,
gordo wrote:

I'd like to use a COUNTIF function with criteria being all visible rows set
in the column filter. Thanks-