Average

[Khalil Handal]

Hi,
I am working with marks, some of it is out of 100 and others are of 200.
Colomn E has the marks and colomn C has the (Out of) mark.
Colomn C Colomn E
100 70
100 80
200 120
........ ....
I want to calculate the average of marks in colomn E.
It is easy if all the marks are out of 100 (average=Total / number of
marks).
i.e. if I have 10 marks out of one hundred then the sum is divided by
10....
What should I do if one or more marks are not of 100 as shown in the exaple
above. What formula should be used to have the average?

I hope I manage to explain what I want!

 

[Per Jessen]

Hi

This is a matrix formula, so you have to confirm it with CTRL+SHIFT+ENTER
not just ENTER:

=SUM(E1:E3/C1:C3)/3

Regards,
Per

 

[Khalil Handal]

Hi again,
for the values in may example i have an answer of 0.7 for the formula!
Am I missing something?

 

[John]

Hi Khalil
The answer is good, just format the cell as percentage, you'll get 70%
HTH
John

 

[John]

You can do it this way also, just change the range to your needs.
=SUM(C1:C3/E1:E3)/COUNT(E1:E3)
Don't forget to Ctrl+Shift+Enter, it's an array formula.
HTH
John

 

[Khalil Handal]

thanks

You can do it this way also, just change the range to your needs.
=SUM(C1:C3/E1:E3)/COUNT(E1:E3)
Don't forget to Ctrl+Shift+Enter, it's an array formula.
HTH
John

 

[John]

You're welcome, glad to help
John

thanks