How can I count cells that meet two criteria within a filtered co.

G

Guest

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count cells in a table that meet multiple criteria 1
Excel Formula 2
Count if dates meet certain criteria 10
Count contiguous cells, or count cell clusters 0
how to get the median of cells that meet a given criteria in excel 1
COUNTIF based on several criteria incl. a "does not equal" criteri 3
I need a cell to populate as a one when 2 cells meet criteria 2
Counting rows that meet multiple criteria 5

Top