Counting textual data

[skippingrock]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I have what seems to me should be a fairly easy task, but I can't seem to find the correct function.

I have a spreadsheet of data from a survey.

In the columns I have results from the user replies.
In the columns that have set answers, I want to be able to count how many times a response was given in the column. For example how many "yes" or "no" answers or in another column how many "disagree", "neutral", or "agree" responses I have.

Can anyhow tell me how to do this, have the results for each answer appear in a separate cell so that I can do more calculations?

Cheers and thanks.
SkipR

 

[CyberTaz]

Hi Skip -

One of the simplest options is to use the COUNTIF() function: Assuming your
Yes/No responses are in cells B10:B200 create these formulas in the
appropriate cells;

=COUNTIF( B10:B200,"Yes")

=COUNTIF( B10:B200,"No")

Use similar formulas for the Agree/Neutral/Disagree column.

There are also other functions in the Statistical category which could be
used but most require that the responses be converted to numerical
equivalents rather than literals.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[skippingrock]

Thanks CyberTaz.