CountIF function with two Criterium

H

hiljay

Greetings -

Is there anyway to make create a COUNTIF function with two different
criterium (i.e. >100 and <=499.99, etc)?

If not, can someone direct me to a function that can assist me in
counting cells that have data with two or more criterium?

Thanks!
 
R

Ron Coderre

Try one of these:

Count values greater than 100 and less than or equal to 499.99:
=SUMPRODUCT((A1:A100>100)*(A1:A100<=499.99))
OR
=COUNTIF(A1:A100,">100")-COUNTIF(A1:A100,"<=499.99")

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron Coderre

Yikes! Thanks for catching that one, RD.
***********
Regards,
Ron

XL2002, WinXP
 
Top