Thread
:
Tabulating Survey Results
View Single Post
#
2
Dave R.
Posts: n/a
Something like this would work;
=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)
"Tabulatin Survey results" <Tabulatin Survey
wrote in message
...
I have just completed a survey in which the recepients answered a question
with a 1-5 response. 1 being Not satisfied 5 being very satisfied - I have
the totals for each response but want to be able to take the total
responses
in each category and create a average result of the question.
Column one has the 1-5 in it - Column 2 has the number of reponses for
each.
I want the answer to be a 1-5 number off all the respondents.
Thanks
Reply With Quote