How to Calculate Percentage Using AutoSum in Excel

A percentage is a relative figure that represents the hundredth portion of any amount. A percentage is calculated using the formula =part/total.  Excel has many features to calculate the percentage of any given data. But in this article, we will explore the AutoSum command to calculate percentage in Excel. So, stay tuned and follow the necessary steps.

What Is AutoSum Command in Excel?

You can navigate to AutoSum through this path.

  • Open Excel >> Create a workbook >> Go to Formulas tab >> Go to Function Library group >> Pick the first command in it, i.e. AutoSum.
  • The AutoSum command has the following Excel functions built in.

SUM function

AVERAGE function

COUNT function

MAX function

MIN function

AutoSum command has the following Excel functions

How to Calculate Percentage Using AutoSum Command in Excel: Easy Steps

⦿ Step 1: Collect Data and Record It in an Excel Sheet

  • Collect necessary data and create an Excel workbook with that.
  • Here, I have collected the Population data of the world by 2022.
  • Now, I am going to find the contribution percentage of each continent in the total population.

Collect Data and Record in an Excel Sheet

⦿ Step 2: Insert Percentage Formula

  • Now, in the Percentage column, enter the following formula to calculate %.
  • Don’t forget to make the C10 cell absolute pressing F4 after it.

Insert Percentage Formula

  • Then drag the fill handle icon to the last cell D10.

drag the fill handle icon

⦿ Step 3: Apply AutoSum Command to Get the Sum

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

How to Calculate Percentage Using AutoSum in Excel

  • As a result, the following will happen.

Final result

  • Press the Enter key.
  • Now, you will see that the Percentage column is showing some results, but they are not in the proper format.

Read More: How to Use AutoSum In Excel 

⦿ Step 4: Apply Percentage Format and Show the Results

  • Now, select cells D5:D10 and press Ctrl+1. The following window will appear.
  • From the Number section, go to Percentage option >> Select suitable Decimal places required and then press OK.

Apply Percentage Format

  • Now, look at the following image, to see the results in the proper format.

Show the Results by Autosum percentage in Excel

Quick Notes

To apply AutoSum easily, you must have some input data prior to that. Otherwise, you have to select the range manually (yes, that can be helpful in some ways).

Download Practice Workbook

You can download the practice workbook from the following download button.


Follow these steps and stages to AutoSum percentage in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comment section.

Related Articles

<< Go Back to Autosum in ExcelSum in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF