Previous posted on microsoft.public.excel ......

Hi Folks - I need to provide counts and percentages of survey data. If
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total
number of answers.

The data looks like this:

Q1 Q2 Q3 ...... etc.
1 2 5
2 3 2
5 1 4

etc.

In the past, I have inserted a blank column between the questions, then used
COUNTIF to count the answers in the Question column, and I have used the
blank column to calculate the percentages. It takes a awhile to setup, so I
was hoping there might be a better way using a pivot table. Any ideas?
Thanks.

Michael

Hi Michael

It may be that the worksheet function Frequency is helpful here to analyse
the numbers of the answers with bins_array 1, 2, 3, 4, 5.

Anthony

"Michael" wrote:

> Previous posted on microsoft.public.excel ......
>
> Hi Folks - I need to provide counts and percentages of survey data. If
> Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
> 1's, 2's, etc., plus calculate the percentage of the counts to the total
> number of answers.
>
> The data looks like this:
>
> Q1 Q2 Q3 ...... etc.
> 1 2 5
> 2 3 2
> 5 1 4
>
> etc.
>
> In the past, I have inserted a blank column between the questions, then used
> COUNTIF to count the answers in the Question column, and I have used the
> blank column to calculate the percentages. It takes a awhile to setup, so I
> was hoping there might be a better way using a pivot table. Any ideas?
> Thanks.
>
> Michael
>
>
>
>
>