Getting a average from a survey

[Guest]

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

 

[Harald Staff]

=(6*1+7*2+14*3+15*4+20*5)/(6+7+14+15+20)

HTH. Best wishes Harald

 

[JE McGimpsey]

One way:

Assuming your data are in B1:B5:

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

 

[Guest]

One way

=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)

Regards,

Peo Sjoblom