Sum of Max cells in a range

Merrick · Feb 23, 2005

Any way to find out the sum of the three greatest values out of a range of 20
cells all in the same row? I'm going crazy...

Peo Sjoblom · Feb 23, 2005

One way

=SUMPRODUCT(LARGE(A4:T4,ROW(INDIRECT("1:3"))))

Domenic · Feb 23, 2005

Try the following...

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

Hope this helps!