Counting Survey Questions

[Michael]

Hi Folks - I have survey data like this:

Site Q1 Q2 Q3
SiteA 1 3 2
SiteA 2 2 1
SiteA 2 1 3
SiteB 1 1 1
SiteB 2 1 3
etc.


How can I use a pivot table to count the number of 1's, 2's and 3's for each
question by site? Thanks for your help.

Michael

 

[Sean Timmons]

I would suggest 3 tables.

Drop Site and Q1 into Row Fields and then drop QA into Data fields as well.

Do the same in table 2 using Q2 instead, and table 3 with Q3...

 

[Ashish Mathur]

Hi,

you can use multiple consolidation ranges to solve this problem. Select the
range and go to Insert > Pivot table. Select multiple consolidation ranges.
Click Next and select "I will create my page fields". Click Next and select
the range and Add. This should create your pivot table.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com