This does it for data that has been filtered
=SUMPRODUCT(SUBTOTAL(3,OFFSET(A1:A10,ROW(A1:A10)-MIN(ROW(A1:A10)),,1)), --(A
1:A10=0),--(A1:A10<=2))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"lizzzy" wrote in message
...
Having trouble counting cells that meet two or more criteria such as
"greater
than or equal to zero" and "less than or equal to 2" in a filtered column.
Only want visible cells to be counted.
|