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