Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting responses - please help
I have survey results in a table - 40 columns x 315 rows (people surveyed) I want to count the responses, e.g. Q #1 had 4 choices - S, L, H or W. How many in column 1 answered "S"? How many "L"? Etc. I have tried SumA, CountA, and DCountA and cannot derive a formula. For instance =COUNTA(H3:H315,"H)") just returns the number of responses in column H - not just the responses with "H" in the cells. Please help ! Here is a sample column showing a few results: S [blank] L S S H S S W S My formula would show for this segment: S had 6 responses, L had 1, W had 1 and H had 1. WH -- woodhands ------------------------------------------------------------------------ woodhands's Profile: http://www.excelforum.com/member.php...o&userid=35298 View this thread: http://www.excelforum.com/showthread...hreadid=550801 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting responses - please help
Never mind, Peo answered this in another thread - it's done with CountIF(H1:H315,"H"). Thanks! -- woodhands ------------------------------------------------------------------------ woodhands's Profile: http://www.excelforum.com/member.php...o&userid=35298 View this thread: http://www.excelforum.com/showthread...hreadid=550801 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting responses - please help
=COUNTIF(H:H,"S")
etc. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "woodhands" wrote in message ... I have survey results in a table - 40 columns x 315 rows (people surveyed) I want to count the responses, e.g. Q #1 had 4 choices - S, L, H or W. How many in column 1 answered "S"? How many "L"? Etc. I have tried SumA, CountA, and DCountA and cannot derive a formula. For instance =COUNTA(H3:H315,"H)") just returns the number of responses in column H - not just the responses with "H" in the cells. Please help ! Here is a sample column showing a few results: S [blank] L S S H S S W S My formula would show for this segment: S had 6 responses, L had 1, W had 1 and H had 1. WH -- woodhands ------------------------------------------------------------------------ woodhands's Profile: http://www.excelforum.com/member.php...o&userid=35298 View this thread: http://www.excelforum.com/showthread...hreadid=550801 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting responses - please help
You're close........try this instead....... =COUNTIF(H3:H315,"H") Vaya con Dios, Chuck, CABGx3 "woodhands" wrote in message ... I have survey results in a table - 40 columns x 315 rows (people surveyed) I want to count the responses, e.g. Q #1 had 4 choices - S, L, H or W. How many in column 1 answered "S"? How many "L"? Etc. I have tried SumA, CountA, and DCountA and cannot derive a formula. For instance =COUNTA(H3:H315,"H)") just returns the number of responses in column H - not just the responses with "H" in the cells. Please help ! Here is a sample column showing a few results: S [blank] L S S H S S W S My formula would show for this segment: S had 6 responses, L had 1, W had 1 and H had 1. WH -- woodhands ------------------------------------------------------------------------ woodhands's Profile: http://www.excelforum.com/member.php...o&userid=35298 View this thread: http://www.excelforum.com/showthread...hreadid=550801 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting responses - please help
thanks for the input. WH -- woodhands ------------------------------------------------------------------------ woodhands's Profile: http://www.excelforum.com/member.php...o&userid=35298 View this thread: http://www.excelforum.com/showthread...hreadid=550801 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding up yes, no, n/a responses | Excel Discussion (Misc queries) | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |