Sum of Max cells in a range

[Guest]

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]

One way

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

 

[Domenic]

Try the following...

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

Hope this helps!