R Ruda Oct 15, 2005 #1 I have 12 cells with some numbers. How can I calculate the sum of the three maximum numbers among them?
I have 12 cells with some numbers. How can I calculate the sum of the three maximum numbers among them?
D Dave Peterson Oct 15, 2005 #2 Something like: =SUM(LARGE(A1:A12,{1,2,3})) I have 12 cells with some numbers. How can I calculate the sum of the three maximum numbers among them? Click to expand...
Something like: =SUM(LARGE(A1:A12,{1,2,3})) I have 12 cells with some numbers. How can I calculate the sum of the three maximum numbers among them? Click to expand...
B Bob Phillips Oct 15, 2005 #3 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)
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)
