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