Thread
:
Sum of Max cells in a range
View Single Post
#
2
Peo Sjoblom
Posts: n/a
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...
Reply With Quote