Countif formula

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
 
S

Sean Timmons

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

Jacob Skaria

Another way

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if conditional formula required 13
need help on MAX 12
Countif to exclude blanks 3
COUNTIF Cells in Range? 4
Combine Two Queries in Different Layouts 2
Sorting and COUNTIF 6
COUNTIF, Sorting, Two Sheets 0
Countif, Sorting => Two Sheets 0

Top