Hi

SUBTOTAL is the function, which uses data filtered by autofilter as source.
The 1st parameter determines, which of 11 various functions is imited - look
for SUBTOTAL worksheet function in MS Excel Help.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


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