Help with SUM function equation

[GMcLaughlin]

Hello all I am new to using the more advanced functions and equations within excel.

Could someone help out with a SUM equation to always include max value of column A as a part of the equation and then add this number to the SUM of the two highest max values from either column B or C or D whichever two columns have the top two highest values.

[TABLE="width: 337"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]297[/TD]
[TD="align: right"]158[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]275[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Max Value[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]297[/TD]
[TD="align: right"]275[/TD]
[/TR]
</tbody>[/TABLE]

I hope my explanation is not confusing as it has seemed to confuse me writing it.

Thank you in advance for your help.

 

[surkdidat]

Will it only be A + 2 of B, C and D , or will there be more columns in the future?
If so could you do :-

=SUM(A5:D5)-MIN(B5:D5)
So adding them all up and taking away the min value (which leaves column A + the two highest from B C or D) ?


[TABLE="width: 360"]


<colgroup><col width="72" style="width: 54pt;" span="5">
<tbody>[TR]

[TD="class: xl65, width: 72, bgcolor: transparent, align: right"]125[/TD]

[TD="class: xl65, width: 72, bgcolor: transparent, align: right"]225[/TD]

[TD="class: xl65, width: 72, bgcolor: transparent, align: right"]125[/TD]

[TD="class: xl65, width: 72, bgcolor: transparent, align: right"]125[/TD]

[TD="class: xl65, width: 72, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl65, bgcolor: transparent, align: right"]158[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]158[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]297[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]158[/TD]

[TD="class: xl65, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl65, bgcolor: transparent, align: right"]32[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]32[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]32[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]275[/TD]

[TD="class: xl65, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl65, bgcolor: transparent, align: right"]87[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]87[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]87[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]87[/TD]

[TD="class: xl65, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl66, bgcolor: transparent, align: right"]158[/TD]

[TD="class: xl65, bgcolor: transparent, align: right"]225[/TD]

[TD="class: xl66, bgcolor: transparent, align: right"]297[/TD]

[TD="class: xl66, bgcolor: transparent, align: right"]275[/TD]

[TD="class: xl66, bgcolor: transparent, align: right"]730[/TD]

[/TR]


</tbody>[/TABLE]

 

[admiral100]

Hi,

If let's say column C contain the two highest values from columns B & C & D ?

=MAX(A1:A4)+SUM(LARGE(B1:D4,{1,2}))

[TABLE="width: 350"]
<colgroup><col width="70" span="5" style="width:52pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 70"][/TD]
[TD="class: xl63, width: 70"]A[/TD]
[TD="class: xl63, width: 70"]B[/TD]
[TD="class: xl63, width: 70"]C[/TD]
[TD="class: xl63, width: 70"]D[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]125[/TD]
[TD="class: xl63"]225[/TD]
[TD="class: xl63"]125[/TD]
[TD="class: xl63"]125[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]158[/TD]
[TD="class: xl63"]158[/TD]
[TD="class: xl63"]297[/TD]
[TD="class: xl63"]158[/TD]
[/TR]
[TR]
[TD="class: xl63"]3[/TD]
[TD="class: xl63"]32[/TD]
[TD="class: xl63"]32[/TD]
[TD="class: xl63"]366[/TD]
[TD="class: xl63"]275[/TD]
[/TR]
[TR]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]87[/TD]
[TD="class: xl63"]87[/TD]
[TD="class: xl63"]87[/TD]
[TD="class: xl63"]87[/TD]
[/TR]
</tbody>[/TABLE]

 

[GMcLaughlin]

Thank you surkdidat That does seem a lot more simple than what I was thinking and I have applied it to my worksheet and it works very nicely.

Again thank you for the prompt and expert help.