Thread: how can I use Excel's COUNTIF to count column entries71 but <110
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
bsr-tmmc
 
Posts: n/a
Default how can I use Excel's COUNTIF to count column entries71 but <110
I have a set of numbers for laboratory tests in a column. I need to COUNT
the numbers of results < 70, the number <=71 but <=110, <=111 but <=140, etc.

An example Cell range would be (A2:A200)

Can I use the COUNT or COUNTIF functions?

Thanks



Reply With QuoteReply With Quote