View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Wanting to add best 3 out of 4 numbers in Excel?

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Bernie Deitrick" <deitbe @ consumer dot org schrieb im Newsbeitrag
...
Frank,

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

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

HTH,
Bernie
MS Excel MVP

"Frank Kabel" wrote in message
...
Hi
try
=SUM(LARGE(A1:A100,<71,2,3<0))

--
Regards
Frank Kabel
Frankfurt, Germany

"GE" schrieb im Newsbeitrag
...
Looking to add best 3 of 4 numbers in Excell, if all 4 numbers

are
the same
etc.