Wanting to add best 3 out of 4 numbers in Excel?

[Guest]

Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same
etc.

 

[Bernie Deitrick]

GE,

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

or

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

depending on what "Best" means (highest or lowest).

And we generally can't read your mind to know exactly what "etc." means.....

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
try
=SUM(LARGE(A1:A100,<71,2,3<0))

 

[Bernie Deitrick]

Frank,

Not sure what character set you're using ;-)

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

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi Bernie
vcery strange. I'm sure i hit the {} keys???
Thanks for the correction

 

[Bob Phillips]

I think something got lost in Franks' post when it hit the NG I am sure it
should be

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

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
thick fingers on my side - I guess )

 

[Bob Phillips]

Doubt it, not close enough. It looks like something happened en-route.

Bob

 

[Frank Kabel]

Hi
on my keyboard layout it is <vbg>
instead of hitting ALTGR I hit the "<>"