Add best 3 of 4 numbers

[Guest]

Looking to add the best 3 of 4 numbers in a spreadsheet. Can not seem to
figure out when all 4 of the numbers are the same.

GE

 

[Frank Kabel]

Hi
see your other post

 

[Bernie Deitrick]

GE,

Either Frank's

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

or my

=SUM(A1:A4) - MIN(A1:A4)

will work in that case.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Use the LARGE function.