Calculate % of Total in excel.

[skipper26]

I am trying to calculate the % of total for a column of numbers.

[#2]

@skipper26 

Not actually an Excel question.

=value/total

[#3]

@skipper26 

Suppose you have a column of numbers like this:

Then, if you have M365 or a version of Excel that supports Dynamic Arrays, you can put this formula in cell C3:

=B3:B12/SUM(B3:B12)

And change the format of the percent column to % by using the Ctrl + Shift + 5 shortcut so that you have this:

If you have an older version of Excel which doesn't support Dynamic Arrays, put this formula in cell C3:

=B3/SUM($B$3:$B$12)

Then, using the fill-handle, drag the formula to the bottom of the column of the numbers. 

For more details on how to use the fill-handle, see this page.