S
sumesh56
hai everybody,
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.
=SUM(((E4:E35)/32))/90*100
help me plz. thanks. have a nice day
+-------------------------------------------------------------------
|Filename: MKLIST FOR EBR.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=620
+-------------------------------------------------------------------
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.
=SUM(((E4:E35)/32))/90*100
help me plz. thanks. have a nice day
+-------------------------------------------------------------------
|Filename: MKLIST FOR EBR.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=620
+-------------------------------------------------------------------