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