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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks