how to add two maximum cell values in row wise

[sivaksekar]

Dear Team,

Please assiSt me how to add two maximum cell values in row wise.

Name Mark 1 Mark 2 Mark 3 Mark 4 EXPECTED_VALUE
A 5 7 5 8 8+5=13
B 10 12 9 13 13+12=25
C 14 15 18 3 18+15=33
D 8 9 12 13 13+12=25


Regards,
Siva

[Rohit_Raj]

Hi Sivaksekar,

can you please attach example excel sheet.

Regards
Rohit

[Glenn Kennedy]

Use this:

=LARGE(A1:D1,1)+LARGE(A1:D1,2)

[AliGW]

Alternatively:

=SUM(LARGE(A1:D1,{1,2}))

We are both assuming that the expected value in A should in fact be 8+7=15!

[sivaksekar]

Thanks Glenn

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

[samba_ravi]

A 5 7 5 8 8+5=13
Why its 8+5=13 why not 8+7=15

[Glenn Kennedy]

nflsales - Ithink that the OP made a mistake...

[AliGW]

nflsales - Ithink that the OP made a mistake...

Which is why I said:

Alternatively:

=SUM(LARGE(A1:D1,{1,2}))

We are both assuming that the expected value in A should in fact be 8+7=15!