Help with Formula

[VinceF]

Greetings,
Assistance much appreciated, hopefully an easy 1 for the experts.

I must use and add the largest 2 numbers in the column
However if Large 3 is >= 1, I want to add that to Large 1 & 2
Also if Large 4 is >= 1 I want to also add that too.
The sum of these numbers will reside in cell D17
I've tried switching the order around, tried using SUMIF all to no avail.

=SUM(LARGE(D13:D16,{1,2},
+IF(LARGE(D13:D16,3>=1),
+IF(LARGE(D13:D16,4>=1)))))

Thank You,
VinceF
Excel 2016
Win 10

 

[Joe4]

Try this:

=SUM(LARGE(D13:D16,{1,2}))+IF(LARGE(D13:D16,3)>=1,LARGE(D13:D16,3),0)+IF(LARGE(D13:D16,4)>=1,LARGE(D13:D16,4),0)

This would be shorter/easier if you were using Excel 365 and had access to the LET function.

In 365, it could look like this:

=SUM(LARGE(D13:D16,{1,2}))+LET(x,LARGE(D13:D16,3),IF(x>=1,x,0))+LET(y,LARGE(D13:D16,4),IF(y>=1,y,0))

 

[VinceF]

Joe4,

It's working perfectly...very much appreciated...you guys are the best...!

VinceF

 

[Joe4]

You are welcome.
Glad I was able to help!