Forum Discussion

skipper26's avatar
skipper26
Copper Contributor
Jan 30, 2024

Calculate % of Total in excel.

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

excel
  • flexyourdata's avatar
    flexyourdata
    Iron Contributor
    Jan 30, 2024

    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.

Resources