Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Range
Hi Folks - Here's my scenario:
I have data like this .... Student Sessions Attended A 12 B 10 C 5 D 3 E 14 F 8 I want to be able to provide the following counts: * The number of students over 12 sessions * The number of students between 8 and 12 sessions * The number of students less than 8 sessions Do-able? Thanks. Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Range
Hi,
try the following array formula (Ctrl+Shift+Enter) =sum(if(range12,1,0)) =sum(if(range<8,1,0)) Regards, Ashish Mathur "Michael" wrote: Hi Folks - Here's my scenario: I have data like this .... Student Sessions Attended A 12 B 10 C 5 D 3 E 14 F 8 I want to be able to provide the following counts: * The number of students over 12 sessions * The number of students between 8 and 12 sessions * The number of students less than 8 sessions Do-able? Thanks. Michael |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Range
Hi Michael
Greater than 12 =COUNTIF(B:B,"12") Between 8 and 12 =COUNTIF(B:B,"8")-COUNTIF(B:B,"12") Less than 8 =COUNTIF(B:B,"<8") -- Regards Roger Govier "Michael" wrote in message news:58JDf.147890$WH.100840@dukeread01... Hi Folks - Here's my scenario: I have data like this .... Student Sessions Attended A 12 B 10 C 5 D 3 E 14 F 8 I want to be able to provide the following counts: * The number of students over 12 sessions * The number of students between 8 and 12 sessions * The number of students less than 8 sessions Do-able? Thanks. Michael |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Range
=COUNTIF(A:A,"12")
=COUNTIF(A:A,"=8")-COUNTIF(A:A,"12") =COUNTIF(A:A,"<8") -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Michael" wrote in message news:58JDf.147890$WH.100840@dukeread01... Hi Folks - Here's my scenario: I have data like this .... Student Sessions Attended A 12 B 10 C 5 D 3 E 14 F 8 I want to be able to provide the following counts: * The number of students over 12 sessions * The number of students between 8 and 12 sessions * The number of students less than 8 sessions Do-able? Thanks. Michael |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Range
Only one column is needed, say column B
=countif(B1:B6,"12") in C1 yields the number greater than 12 =countif(B1:B6,"<8") in D1 yields the number less than 8 =count(B1:B6)-C1-D1 yields the number in the middle -- Gary's Student "Michael" wrote: Hi Folks - Here's my scenario: I have data like this .... Student Sessions Attended A 12 B 10 C 5 D 3 E 14 F 8 I want to be able to provide the following counts: * The number of students over 12 sessions * The number of students between 8 and 12 sessions * The number of students less than 8 sessions Do-able? Thanks. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Countif for specific cells rather than a range ???? | Excel Worksheet Functions |