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

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...

"Michael" wrote:

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

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

"Michael" wrote in message
...
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