Skip to content

Percentage of total

Show each row's share of the column total.

The formula

Argument separator
Excel and Google Sheets
=B2/SUM($B$2:$B$100)

How it works

  1. B2

    This row's value.

  2. SUM($B$2:$B$100)

    The total of the whole column. $ keeps it fixed when you fill down.

Example

A: RegionB: SalesC: Result (as %)
North30030%
South50050%
West20020%

Tips

  • Format the result as Percentage. All rows add up to 100%.