Add up the largest few values in a range, e.g. the top 3.
Copy this formula
=SUM(LARGE(B2:B100, {1,2,3}))LARGE returns the k-th largest value; passing an array constant {1,2,3} returns the top three, and SUM totals them. Change the constant to set how many. Use SMALL for the bottom N.
=SUM(LARGE(B2:B100, {1,2,3,4,5}))→9,800Total of the five largest values.
In Excel 365 no; in older versions, array constants like this usually still work without it, but enter as an array if you see a single value.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.