Share of total and percent change formulas
What share of the total a row is, and how much it changed from the previous row.
The problem
You want each item's share of the total and its percent change.
Sample data
Column C: 1000, 450, 100, 100 (rows 2-5).
Formulas
Share: =ROUND(C2/SUM(C$2:C$5),4) -> 0.6061 (format as % for 60.61%)
Change: =(C3-C2)/C2 -> -0.55 (-55%)
If the old value is 0, the change formula divides by zero.
Excel vs Sheets
Same in both.
Tested on sample data by the Cellwise checker (log CW-PL-20261018-42). AI-made: the text, voice and visuals are generated by AI.
Checked before publishing: a check.