Thread: Countif formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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