Sum of Max cells in a range
 

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

One way

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

--

Regards,

Peo Sjoblom



"Merrick" wrote in message
...
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...

Try the following...

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

Hope this helps!

In article ,
"Merrick" wrote:

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