Countif formula

  • Thread starter Thread starter bel23
  • Start date Start date
B

bel23

I need to count how many times someone fall under a different range of numbers

EX: Top 1-160, 2nd 161-320, 3rd 321-500

I know how to count for the top but not sure on the 2nd and 3rd.

My Top I did =COUNTIF(G7:S7,"=160")

How do I count the next range? 161-320

Thank you for any help
 
Presuming you meant

=COUNTIF(G7:S7,"<=160")

Then you can do

=COUNTIF(G7:S7,"<=320")-COUNTIF(G7:S7,"<=160")

and

=COUNTIF(G7:S7,"<=500")-COUNTIF(G7:S7,"<=320")
 
Back
Top