COUNTIF >=8 AND < 9

[Jenni]

I have a worksheet that contains employees in one column
an wages in another. I would like to count how many
people make Greater than or Equal to 8, but less than 9
dollars an hour. and 9 to 10. and 11 to 12. I think I can
use COUNTIF, but I'm not sure how to say >=8 AND <9 Can
you help?

 

[Anson]

Hi Jenni

Try use the Array Sum function below:
Sum((A1:A10>=8)*(A1:A10<=9))

instead of hitting <Enter>, hit <Ctrl> + <Shift> + <Enter>

 

[Don Guillett]

try
=sumproduct((a2:a200>8)*(a2:a200<=9))

 

[Domenic]

Hi Jenni,

Assuming your data is in Column B, try:

=SUMPRODUCT((B1:B10>=8)*(B1:B10<9))

Hope this helps!

 

[Bob Umlas Excel MVP]

=SUMPRODUCT((A1:A100>=8)*(A1:A100<9))
and
=SUMPRODUCT((A1:A100>=9)*(A1:A100<10))
etc.

 

[Juan Sanchez]

If you are only countig ranges of 1 integer maybe you can
use:

=SUMPRODUCT(--(INT(A1:A30)=8))

Change 8 for 9 and then 10 and so on...

Cheers
Juan

 

[Don Guillett]

Neat, then this might even be easier to copy down

=SUMPRODUCT(--(INT(F1:F30)=ROW(A8)))

 

[Jenni]

Thank you! That works great!

-----Original Message-----
Hi Jenni

Try use the Array Sum function below:
Sum((A1:A10>=8)*(A1:A10<=9))

instead of hitting <Enter>, hit <Ctrl> + <Shift> +