To calculate the percentage of total in Excel, use the formula: =Part/Total. Enter the formula by referencing the cell containing the part value, and use an absolute reference for the total value (e.g., =B2/$B$10). Then, format the result as a percentage.
https://excelsamurai.com/formula-to-calculate-percentage-of-total-in-excel/



