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.

	A	B	C	D
	125	225	125	125
	158	158	297	158
	32	32	32	275
	87	87	87	87
Max Value	158	225	297	275

<tbody>
</tbody>

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) ?

125	225	125	125
158	158	297	158
32	32	32	275
87	87	87	87
158	225	297	275	730

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



































</tbody>

 

[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}))

	A	B	C	D
1	125	225	125	125
2	158	158	297	158
3	32	32	366	275
4	87	87	87	87

<colgroup><col width="70" span="5" style="width:52pt"> </colgroup><tbody>
</tbody>

 

[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.