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.