Countif formula
 

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

Countif formula
 

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")



"bel23" wrote:

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

Countif formula
 

Another way

=SUMPRODUCT((G7:S7=161)*(G7:S7<=320))

If this post helps click Yes
---------------
Jacob Skaria


"bel23" wrote:

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