Total 5 highest numbers in single column

[clifnote]

I wish to sum the 5 highest numbers in a single column.

Sum in cell B1, B2:B25 has both positive and negative numbers

thanks in advance

Clif

 

[Piktro]

In B1

=SUM(LARGE(B2:B25,{1,2,3,4,5}))

Use Ctrl+Enter when pasting the formula.

 

[clifnote]

Thank you Piktro - works perfectly

 

[s hal]

You could also do a variation of what Piktro suggests in case you wanted more than just the top 5 (also a CSE function); the below is for the 5 largest, but if you increase 5 to a higher number, it would sum the next Nth number:

=SUM(LARGE(B2:B25,ROW(INDIRECT("1:5"))))

 

[Piktro]

You could also do a variation of what Piktro suggests in case you wanted more than just the top 5 (also a CSE function); the below is for the 5 largest, but if you increase 5 to a higher number, it would sum the next Nth number:

=SUM(LARGE(B2:B25,ROW(INDIRECT("1:5"))))

1-Upped again! Haha