How to Calculate Percentage Using AutoSum in Excel

Step 1 – Collect Data and Record It in an Excel Sheet

Collect necessary data and create an Excel workbook.

For the sample dataset, we have collected the Population data of the world for 2022. We will find the contribution percentage of each continent in the total population.

Step 2 – Insert Percentage Formula

In the Percentage column, enter the following formula to calculate %.

=C5/$C$10

Make the C10 cell absolute by pressing F4.

Drag the fill handle icon to the last cell D10.

Step 3 – Apply AutoSum Command to Get the Sum

Click on cell C10 and go to the Formulas tab.
From the Function Library group, click on the AutoSum drop-down.
Select the Sum option from the list.

The following will result as shown in the image below.

Press Enter.

You will see that the Percentage column is showing some results, but they are not in the proper format.

Step 4 – Apply Percentage Format and Show the Results

Select cells D5:D10 and press Ctrl+1. Format Cells window will open.
From the Number section, go to Percentage option >> Select suitable Decimal places required and press OK.