347 647 9001+1 714 797 8196Request a Call
Call Me

Using Auto Sum function in Excel

March 9, 2015
, , , , , , ,

Whether you are a multi millionaire sitting in your air conditioned cabin or a regular housewife doing her daily grocery shopping, one of the common task that is performed by both is adding the numbers. Yes, in one case we are talking about millions and in other a few hundreds but the point is, you require the adding functions irrespective of your position. AutoSum is one of the most commonly used functions Excel. Along with AutoSum you can also use the functions like Average, Max, Min etc. you can avoid using the formula by using the AutoSum function.

How to use AutoSum function in Excel?

1. In our example, we want to know the total sales at the end of the year for each location and therefore we shall use AutoSum function.

Using the AutoSum function in Excel

2. On the right hand side of the home tab, you shall find the option of AutoSum. When you will click on the dropdown you shall find various options like Sum, Average, Count, Max and Min. Since we need the total we shall select the sum option.

AutoSum option in the ribbons menu

3. When you select the option of AutoSum, it will automatically guess the range of the cells to be added. If you want, you can change the range.

Range selection in Excel’s AutoSum function

4. Press enter and you shall receive the sum of the entire column.

AutoSum function Excel

5. To know the Sum of other locations ( NewYork, Sydney, New Jersey ) just drag the fill handle from B14 to E14 and you shall get your respective totals.

Using fill handle in AutoSum function

Similarly you can also use the other functions like Average, Count, Maximum and Minimum by selecting the respective option in the AutoSum dropdown (See step 2)

Points to remember while using AutoSum function

  • To know the sum of a particular column, select the cell immediately below the last number in the column. To know the sum of a particular row, select the cell immediately to the right.
  • You can find the AutoSum function in tabs that are Home and Formulas.
  • You can also use the shortcut to use AutoSum function that is, Alt + H + U.
  • You can use the AutoSum function for more than one cell. In the example above, if you select B14 to E14 instead of selecting B14 alone, then you shall receive the sum of all the columns at once without using the fill handle.

If you have any queries or doubts, do mention it in the comments box below and we shall get back to you as early as possible.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 72280