# How to find the items that make up 80% of the total in Excel

Sort largest first, then flag a row while the total of the rows above it is still under 80% of the grand total: =IF(SUM($B$2:B2)-B2<0.8*SUM($B$2:$B$8),"Top 80%","").

**Excel:** `=IF(SUM($B$2:B2)-B2<0.8*SUM($B$2:$B$8),"Top 80%","")` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| Product | Revenue | Group |
| Laptops | 86400 |  |
| Monitors | 52300 |  |
| Docks | 31800 |  |
| Keyboards | 18900 |  |
| Mice | 12400 |  |
| Cables | 6700 |  |
| Stands | 4300 |  |

Formula in C2, filled to C8: `=IF(SUM($B$2:B2)-B2<0.8*SUM($B$2:$B$8),"Top 80%","")`

Result: Top 80%; Top 80%; Top 80%; ; ; ; 

## How it works

This is a Pareto (80/20) analysis. `SUM($B$2:B2)-B2` is the running total before the current row. While that is still under 80% of the grand total, the current row is needed to reach the target, so it gets flagged.

The row that crosses 80% is included, because without it you would not reach the target.

## Other ways

- `=IF(SUM($B$2:B2)/SUM($B$2:$B$8)<=0.8,"Top 80%","")`: Simpler to read. (Leaves out the row that crosses 80%, so it can stop short of the target.)

## Common mistakes

- The list must be sorted largest first or the running total means nothing. Sort a copy of the data with SORT or the Sort button first.
- Lock the grand total with $ on both ends.

## Questions

**How do I show the cumulative percentage too?**

`=SUM($B$2:B2)/SUM($B$2:$B$8)` in another column, formatted as a percentage.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-11-20.

Source: https://spreadsheetpractice.com/formulas/find-items-that-make-up-80-percent-of-total
