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
|