You can use a SUMPRODUCT formula to give you the equivalent of COUNTIF
but for two conditions (group and score), and then calculate your
percentages from that. You won't have to sort the data or to set up
subtotals. I would suggest doing this on another sheet and setting it
up like this:

Group Score Question1 Question2 Question3 etc
HR 1
HR 2
HR 3
HR 4
IT 1
IT 2

and so on.

Then in C2 you can enter this formula:

=SUMPRODUCT((Sheet1!$A$2:$A$100=$A2)*(Sheet1!B$2:B $100=$B2))

assuming you have 100 rows of data on Sheet1 - adjust if you have
more. Be careful where you put the $ symbols. The formula can be
copied across and down to give you the counts of the Group and Score
for each question, from which you should be able to derive your
percentages in adjacent columns.

Hope this helps.

Pete

On Sep 22, 10:48*pm, Tina K wrote:
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,