COUNTIF >=8 AND < 9

  • Thread starter Thread starter Jenni
  • Start date Start date
J

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?
 
Hi Jenni

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

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

Assuming your data is in Column B, try:

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

Hope this helps!
 
=SUMPRODUCT((A1:A100>=8)*(A1:A100<9))
and
=SUMPRODUCT((A1:A100>=9)*(A1:A100<10))
etc.
 
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
 
Neat, then this might even be easier to copy down

=SUMPRODUCT(--(INT(F1:F30)=ROW(A8)))
 
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> +
Click to expand...
 
Back
Top