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

HTH. Best wishes Harald

"rickvin" skrev i melding
...
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