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.
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.
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.
4. Press enter and you shall receive the sum of the entire column.
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.
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)
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.
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 email@example.com and we will rectify it.
2015 © Edupristine. ALL Rights Reserved.