# Total 5 highest numbers in single column

#### clifnote

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

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

Clif

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
In B1

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

Use Ctrl+Enter when pasting the formula.

Thank you Piktro - works perfectly

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"))))

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

Replies
6
Views
76
Replies
5
Views
133
Replies
14
Views
407
Replies
2
Views
183
Replies
8
Views
165

1,196,487
Messages
6,015,493
Members
441,898
Latest member
kofafa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back