Thread
:
counting responses - please help
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
paul
Posts: n/a
counting responses - please help
countif(
--
paul
remove nospam for email addy!
"woodhands" wrote:
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
Reply With Quote