Get percentage of total

=amount/total
To calculate percent of a total (i.e. calculate a percent distribution), you can use a formula that simply divides an amount by the total. In the example shown, the formula in D6 is:
=C6/$C$11
Note: the result is formatted with Percentage number format to show 25%, 10%, etc.
In the example, D6 contains the formula below, copied down:
=C6/$C$11
In cell D6, the result of the calculation is .625. The Percentage number format is applied to cell D6, with 2 decimal places, so Excel displays .625 as 63%.
The reference to C11 is absolute (i.e. $C$11) so that it won't change when the formula is copied down column D. This means that each value in column C will be divided by the same total in C11.
Percentage vs number
When you want to display a percentage in Excel, use the Percentage number format, which will automatically display a decimal value as a percentage. If you want a simple number instead without a percent sign (i.e. 75, 85, 100, etc.) you can multiply by 100:
=(C6/$C$11)*100
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.