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
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks