Sum of 3 maximum numbers

R

Ruda

I have 12 cells with some numbers. How can I calculate the sum of the three
maximum numbers among them?
 
B

Bob Phillips

Just for fun

=IF(COUNT(A1:A12)=0,"",SUM(LARGE(A1:A12,ROW(INDIRECT("1:"&MIN(3,COUNT(A1:A12
)))))))

as an array formula, so commit with Ctrl-Shift-Enter.

This caters for less than 3 numbers, without an error

--

HTH

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