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

how can I use Excel's COUNTIF to count column entries71 but <110
 

Your description is somewhat confusing, if you mean greater than or equal to
71 you should use

=71

if that's the case

=COUNTIF(A2:A200,"=71")-COUNTIF(A2:A200,"110")

Do the same for the rest

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"bsr-tmmc" wrote in message
...
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