Getting a average from a survey

R

rickvin

I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of the
totals.

Can someone please help
 
J

JE McGimpsey

One way:

Assuming your data are in B1:B5:

=SUMPRODUCT(B1:B5,{1;2;3;4;5})/SUM(B1:B5)
 
Top