Measuring number of occurences in a list

[James]

Hello everyone,

I have a list that comes out of an online questionnaire and I would like to
measure (as a count, and percentage) the number of occurences of a
particular reply to each question. Here is an example below of the layout
of the table :

postDate email Region
Question04 Question05 Question06
17/06/2004 16:28 (e-mail address removed) North America
Satisfactory Better in the Afternoon From Both
17/06/2004 16:18 (e-mail address removed) Asia Pac Good
Better in the Morning From the Office
17/06/2004 16:16 (e-mail address removed) North America Very Good
No Difference From Both
17/06/2004 16:13 (e-mail address removed) North America Good
Better in the Morning From Both
17/06/2004 16:11 (e-mail address removed) North America Poor
No Difference From Both
17/06/2004 15:57 (e-mail address removed) North America
Satisfactory Better in the Morning From the Office
17/06/2004 15:55 (e-mail address removed) North America Very Poor
No Difference From Both
17/06/2004 15:52 (e-mail address removed) North America Good
Better in the Afternoon From Both
17/06/2004 15:52 (e-mail address removed) North America Good
No Difference From the Office

I have tried using a pivot table but the problem is that the data are in
column format and not list format.

Thanks very much for any help that you can give me.

James

 

[BrianB]

Don't see a problem with this in a pivot table. eg. for Question 6 us
Question 6 field as Row or Column and Question 6 (Count) as data.

Otherwise have a look at the =COUNTIF() worksheet function

 

[James]

Hi Brian,

sure I can do that but can wondering how to do it for multiple questions.
Thanks for your reply.

James