Average

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

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!
 
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
 
Hi again,
for the values in may example i have an answer of 0.7 for the formula!
Am I missing something?
 
Hi Khalil
The answer is good, just format the cell as percentage, you'll get 70%
HTH
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
 
thanks

John said:
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
Click to expand...
 
Back
Top