Each row in B is a line amount. Show that row as a percent of the column total

公式

=B2/SUM($B$2:$B$100)

说明

Divide the line by the locked total. Absolute $B$2:$B$100 stays fixed as you copy the formula down. Format the cell as Percentage.

步骤

  1. SUM of the amount column is the denominator.
  2. Lock the total with $ so fill-down stays correct.
  3. Format as % with 1–2 decimal places.

变体

Percent of visible total (365)

Whole-column SUM is simple; prefer a bounded range on huge sheets.

=B2/SUM(B:B)

Running percent of total

Cumulative share — useful for Pareto charts.

=SUM($B$2:B2)/SUM($B$2:$B$100)

Percent change vs previous row

Period-over-period, not share of total.

=(B3-B2)/B2