I have a feedback sheet that i need to calculate an average on the rating
given.

the feedback rating is 1-4 with 1 being bad, 4 being good.
It currently looks like this:
RATING 1 2 3 4
NUMBER 5 39 113 227

So 5 people have given a rating of 1, 39 people have given a rating of 2 etc
etc

How can i calculate the avereage rating....ie our average rating is 3.7 etc?

Thanks

>our average rating is 3.7 etc?

I think the correct result should be 3.46

=SUMPRODUCT(B1:E1,B2:E2)/SUM(B2:E2)


--
Biff
Microsoft Excel MVP


"Maggie" <(E-Mail Removed)> wrote in message
news:38D8AB91-0CEC-440B-8B9D-(E-Mail Removed)...
>I have a feedback sheet that i need to calculate an average on the rating
> given.
>
> the feedback rating is 1-4 with 1 being bad, 4 being good.
> It currently looks like this:
> RATING 1 2 3 4
> NUMBER 5 39 113 227
>
> So 5 people have given a rating of 1, 39 people have given a rating of 2
> etc
> etc
>
> How can i calculate the avereage rating....ie our average rating is 3.7
> etc?
>
> Thanks