Calculate average score based on number of responses

[Nurket]

Hello,

I've played with this way to much and it's all just a mess in my head at the moment, so excuse me if the solution is easy and laying around on this forum, I haven't found it - so if the solution is here, please post a link

The setup - Example

I send a couple of questions to my customers where they can rate me from 1 to 10. I add the responses in Excel based on number of responses with the score of 1, 2, 3 etc.

In Excel, I have A1 with the value of 1 (lowest score) through to J1 with the value of 10 (highest score). In A2, B2, C2 etc, I add the number of scores from the responses.

Now, my question is how to I calculate the average score based on the number of scores from responses with the weight (1-10) they have? I can't seem to find the correct formula, or wrap my head around how it works.

I would appreciate all the help I can get.

Kind regards.

[daddylonglegs]

You can use this formula to get the average score

=SUMPRODUCT(A1:J1,A2:J2)/SUM(A2:J2)

SUMPRODUCT gives you the total of all the scores, SUM gives the number of responses, dividing the former by the latter gives the average

[Nurket]

Thank you so much! This solved my frustration, and I'm so happy now.

Thanks for the quick response as well!