Calculating an average
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" wrote in message
...
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
|