Hi Everyone,

I am analzying the results of a survey for our company and I am wondering if
there is a better (smarter) approach in accomplishing what I want.

SCENARIO: I have an Excel spreadsheet full of data from the results of a
survey. The first row has field names (A1-J1) A1=Group Name, (ie. HR,
IT,), B2= Question 1, C1= Question 2, etc... In the rows just below are
random values, ranging from 1-4. 4= Strongly agree, 3= Somewhat agree,
2=Somewhat disagree, 4= Disagree. I want to calculate the % range of answers
from each dept for each question.

My very very long Solution: I sorted by Group (A1), then ran subtotals to
give me the count at each change of group. Next I wrote a Countif formula to
calculate the count for the first group(I added 4 rows underneath the
subtotal count), then wrote another formula next to this to divide this count
to the subtotal count, then formated the # to %. This works fine, but with
the amount of groups and questions ahead, if I did this manually it could
take some time.

Does anyone have another way to approach this?

Thanks in advance,