Thread: Greater than Less than formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help with Check Mark!! Help with Check Mark!! is offline
external usenet poster
  
Posts: 1
Default Greater than Less than formula
I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need to
know the count of B6:B31 that are greater than 30 but less than 39. etc. How?
Reply With QuoteReply With Quote