Get percentage of total

Get percentage of total

Generic formula 

=amount/total

Related formulas 

Percent of goal

Get total from percentage

Get percent change

Increase by percentage

Decrease by percentage

Explanation

To calculate percent of a total (i.e. calculate a percent distribution), you can use a formula that simply pides an amount by the total.

Note: you must format the result using the Percentage number format in Excel to see 25%, 10%, etc.

How the formula works

In the example, the active cell contains this formula:

=C6/$C$11

Excel simply pides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Note: the reference to C11 is absolute (i.e. $C$11) so that it won't change when the formula is copied down the column.

As always in Excel, when you want to display a percentage, you need to use the Percentage number format, which will automatically display a decimal value as a percentage.

Get percentage of total

Generic formula 

=amount/total

Related formulas 

Percent of goal

Get total from percentage

Get percent change

Increase by percentage

Decrease by percentage

Explanation

To calculate percent of a total (i.e. calculate a percent distribution), you can use a formula that simply pides an amount by the total.

Note: you must format the result using the Percentage number format in Excel to see 25%, 10%, etc.

How the formula works

In the example, the active cell contains this formula:

=C6/$C$11

Excel simply pides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Note: the reference to C11 is absolute (i.e. $C$11) so that it won't change when the formula is copied down the column.

As always in Excel, when you want to display a percentage, you need to use the Percentage number format, which will automatically display a decimal value as a percentage.