How do I work out what the average score out of 10 is?

[tonywatsonhelp]

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

	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>

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	10	9	8	7	6	5	4	3	2	1
2	30	40	35	46	27	57	35	36	47	23		5.515957
Sheet1

Cell Formulas
Range	Formula
L2	=SUMPRODUCT($A$1:$J$1,$A$2:$J$2)/SUM($A$2:J$2)

WBD

 

[AkaTrouble]

edit i misunderstood

 

[Peter_SSs]

Like this?

Edit: Ooops, looks like I was a bit slow.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Score out of 10	10	9	8	7	6	5	4	3	2	1	Average Score?
2	Number that scored you	30	40	35	46	27	57	35	36	47	23	5.515957447
Average

 

[tonywatsonhelp]

Thanks AKA and Peter,
Big help

Tony

 

[AkaTrouble]

Thanks AKA and Peter,
Big help

Tony

thx wideboydixon

and Peter_SSs

me thinks you meant

 

[AhoyNC]

You may also want to look at this PDF on Likert scales.
http://my.ilstu.edu/~eostewa/497/Likert topic-dane-likert.pdf