Calculating the percent of total is a common task for analyzing data distribution. This guide shows you how to use absolute cell references to perform this calculation efficiently.
AI に任せるCalculate the grand total
Use the =SUM() function at the bottom of your data column to find the grand total.
Set up the percentage formula
In the cell next to your first data point, type '=' followed by the cell reference, a forward slash '/', and the grand total cell reference.
Use absolute references
Add dollar signs ($) to the grand total cell reference (e.g., $B$10) to lock it, then press Enter.
Format as percentage
Drag the fill handle down to apply the formula, then click the '%' button in the Home tab's Number group.
=A2/$A$10This error occurs if your grand total cell is empty or contains a zero, causing a division by zero.