Function to get maximum marks

[Arhant]

Greetings

I am preparing a mark sheet for 5 subjects 10 marks each. Total 50 marks

On entering the subject marks range from 0-10 total marks I am using SUM function

Last column I have max marks attempted. How to get the total for it on entering marks from 0-!0

Sub 1 sub2 sub3 sub4 sub 5 total marks max marks attempted
0 4 7 11 30


In the last column I should get 30 automatically.

Please help

Thanks ..Anil

 

[Yongle]

With marks in range B2:F2
assumes that the cell is EMPTY if no attempt made
assumes all subjects carry equal marks (10)

=COUNT(B2:F2)*10

 

[Yongle]

a longer formula

=ISNUMBER(B2)*10+ISNUMBER(C2)*10+ISNUMBER(D2)*10+ISNUMBER(E2)*10+ISNUMBER(F2)*10

which you could then use if the max marks differered between subjects

=ISNUMBER(B2)*10+ISNUMBER(C2)*20+ISNUMBER(D2)*10+ISNUMBER(E2)*25+ISNUMBER(F2)*2

explanation
=ISNUMBER(B2) evaluates to TRUE or FALSE

convert TRUE or FALSE to 1 or 0 by multiplication
=TRUE*1 evaluates to 1 =FALSE*1 evaluates to 0

multiply each one by the appropriate marks and add

 

[Arhant]

greetings,

purpose is served.. thanks a ton for the timely support and formula explation...