How to sum the top N values in a range
✓ Verified in LibreOffice 25.8.7.3Add up just the largest few numbers, e.g. your top 3 sales.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =SUMPRODUCT(LARGE(A2:A6,{1,2,3})) | Change {1,2,3} to {1,2,3,4,5} etc. for a different N. |
| Google Sheets | =SUMPRODUCT(LARGE(A2:A6,{1,2,3})) | Identical. |
| LibreOffice Calc | =SUMPRODUCT(LARGE(A2:A6,{1,2,3})) | Identical. |
How it works
LARGE(range, {1,2,3}) returns the 1st, 2nd and 3rd largest values as an array (50, 40, 30); SUMPRODUCT adds them up to 120. Expand the array constant to sum a different number of top values.
Verified, not just documented
We ran =SUMPRODUCT(LARGE(A2:A6,{1,2,3})) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 120 — exactly the expected result. Every formula here is confirmed by actually executing it.