Multiple arguments using the COUNTIF function

G

Guest

How do I use the COUNTIF function with multiple criteria? As an example,
count all entries in a column range that are greater than 10 and less than or
equal to 20.
 
K

Kevin Stecyk

Anon,

=SUMPRODUCT((YourRange>10)*(YourRange<=20))

Hope that helps.

Regards,
Kevin


How do I use the COUNTIF function with multiple criteria? As an example,
count all entries in a column range that are greater than 10 and less than
or
equal to 20.
 

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

Excel Need Countifs Formula Help 0
countif with multiple criteria 5
Counting Cells with Multiple Range Criteria (Excel 2003) 7
COUNTIF Function on filtered data 2
counting numbers within a range 2
COUNTIFS - Excel 07 2
CountIf or sumproduct 1
Escel: Count students >=20 and <=29 1

Top