percentage calculation

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
+-------------------------------------------------------------------
 
P

plinius

Il 13/10/2012 03:20, sumesh56 ha scritto:
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|
+-------------------------------------------------------------------+


=AVERAGE(E4:E35)/90*100

E.
 
S

sumesh56

plinius;1606321 said:
Il 13/10/2012 03:20, sumesh56 ha scritto:-


=AVERAGE(E4:E35)/90*100

E.

thanks a lot for both Isabella and Plinius for the reply. very happy t
find that both the formulas works for me. but can u plz explain wher
was the text occured in between the numbers which caused for the error

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
P

plinius

Il 14/10/2012 04:54, sumesh56 ha scritto:
thanks a lot for both Isabella and Plinius for the reply. very happy to
find that both the formulas works for me. but can u plz explain where
was the text occured in between the numbers which caused for the error?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

Removing unnecessary brackets, your formula is:

=SUM(E4:E35/32)/90*100

E4:E35 is not a single value dividing by 32 but a matrix, therefore it
is a matricial formula and can work correctly only if confirmed by
CONTROL+SHIFT+RETURN

Hi,
E.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top