tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I'm probably missing something really simple here but I cant get it
So below I have an example
First row is the score that was given when we asked how good our service was out of 10
the second row is the number of people scoreing us that number
So 30 people gave us 10 out of ten, 23 1 out of ten etc.
I want find out what our average score was?
what formula do I need to calculate this?
Tony
<tbody>
</tbody>
I'm probably missing something really simple here but I cant get it
So below I have an example
First row is the score that was given when we asked how good our service was out of 10
the second row is the number of people scoreing us that number
So 30 people gave us 10 out of ten, 23 1 out of ten etc.
I want find out what our average score was?
what formula do I need to calculate this?
Tony
A | B | C | D | E | F | G | H | I | J | L | M | N | O | |
Score out of 10 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | Average Score? | |||
Number that scored you | 30 | 40 | 35 | 46 | 27 | 57 | 35 | 36 | 47 | 23 | ???? |
<tbody>
</tbody>