Hello,

I am in need of some help. I have a list after running a macro that brings
back the "question #" (Column 1), Buyer Group decision to the question
(Column 2), which is in the form of a number between 1 -5. The macro runs
each survey, so there could be 7 columns with "question #" and 7 columns of
"buyer Group decision to the question" if there are 7 returned survey's.

So, how can I automatically add all these together, so that a total number
is reported for each question. So if there are 6 buyer groups labeled
"Males" and they respond to question #1 with 5, then I would like to have 30
totaled for me in the pivot report, but I would like to have this automatic.

Any thoughts...I hope this is clear.