COUNTIF Subtotal Function?
=SUMPRODUCT(--($C$2:$C$205),(SUBTOTAL(3,OFFSET($C$2,ROW($C$2:$C $20)-MIN(ROW
($C$2:$C$20)),,))))
will count how many cells in C2:C20 are greater than 5 in a filtered list
adapt to fit
--
Regards,
Peo Sjoblom
"jcpotwor" wrote in message
...
is there a countif for the subtotal function? I could like to perform a
countif on a list which I have autofiltered on. THANKS!
|