One way

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


Regards,

Peo Sjoblom

"havocdragon" wrote:

Hey all. I can't think of anything that would let me do this, but lets say I
have a column (we will say column A) that contains numbers from row 1 to row
100. I would like to put a formula at the bottom of this tha will calculate
the top 3 numbers in this column and sum them together.