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

Never mind, Peo answered this in another thread - it's done with CountIF(H1:H315,"H").

Thanks!

=COUNTIF(H:H,"S")

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"woodhands" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

You're close........try this instead.......

=COUNTIF(H3:H315,"H")

Vaya con Dios,
Chuck, CABGx3


"woodhands" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

thanks for the input.
WH

countif(
--
paul
[email protected]
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
>
>