Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column A = X, Column B =y count = count +1 | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |