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 [email protected] North America
Satisfactory Better in the Afternoon From Both
17/06/2004 16:18 [email protected] Asia Pac Good
Better in the Morning From the Office
17/06/2004 16:16 [email protected] North America Very Good
No Difference From Both
17/06/2004 16:13 [email protected] North America Good
Better in the Morning From Both
17/06/2004 16:11 [email protected] North America Poor
No Difference From Both
17/06/2004 15:57 [email protected] North America
Satisfactory Better in the Morning From the Office
17/06/2004 15:55 [email protected] North America Very Poor
No Difference From Both
17/06/2004 15:52 [email protected] North America Good
Better in the Afternoon From Both
17/06/2004 15:52 [email protected] 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