| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I count cells that meet two criteria within a filtered co.
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
| Count cells with data | New Users to Excel | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Linear Mode
