Posted in Sapiosexual Get percentage of total – Excel formula | Exceljet June 20, 2025 To calculate the percent of a total (i.e. calculate a percent distribution), you can use a formula that simply divides a given amount by the total. In the example shown, the formula in D6 is: =C6/total where total is the named range C15. https://exceljet.net/formulas/get-percentage-of-total