How do you use the AutoSum button to make a SUM function?
Autosum is a very handy tool in Excel to sum cells very fast. Autosum adds up a range of numbers automatically and places the result in a nearby cell. To perform Autosum, click a nearby cell and click Autosum on the Home tab and press Enter. In this tutorial, you will learn how to use autosum in Excel. Show
How to AutoSum in ExcelYou can use the autosum feature from two locations in the ribbon.
Or
Examples of AutosumHow to Autosum a column in ExcelIn the following example, you have the monthly sales for the first quarter of the year. To find the total sales using Autosum:
Keep in mind when you click Autosum, Excel will include the empty cells B6 and B7 in the selection. This can be handy if you decide to add more rows in the future. To stop having the empty cells in the selection, select cell B2:B5 before clicking Autosum. How to Autosum Cells in Multiple Columns in ExcelIn this example, we have the fruit sales for the months in the first quarter broken down for each month. To Autosum the cells in each column at once:
How to Autosum Cells in a Row In this example, you have the fruit sales for the first quarter of the year in a horizontal format. To add the data row-wise:
How to Autosum Rows and Columns at the same time In the previous example, to add up the rows and columns at the same time:
Using Autosum with Other FunctionsExcel’s AutoSum can be used to insert other functions apart from addition. Here’s a list of function supported by Autosum:
To insert functions, other than SUM, you need to select a cell where you want to insert a formula, click the drop-down near AutoSum, and choose the function you desire from the list. For example, to find the average sales from the fruit sales:
This will show the average for each month. Selecting More Functions from the AutoSum drop down list, Excel will open the Insert Function dialog box. This is the same dialog box that open when you click Insert Function button from the Formulas tab or the fx button from the formula bar. Autosum-Workflow BasicsAutosum follows a simple predefined algorithm to decide which cells to include in the selection. But it often runs into problems. The main reason behind Excel Autosum not working is using it without knowing how it works.
But not in this case:
However, if you select the cells you want to add, the gap will be ignored:
However, if you select the range, the non-numeric value in the range will be ignored: An exception to this, autosum will not work if the non-numeric value is an error. The formula used by Autosum will work, but the error will stop it calculating the result. Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. How does AutoSum button work?AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. For example, if you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (shown right).
What is the AutoSum function in Excel?The Autosum Excel Function[1] can be accessed by typing ALT + the = sign in a spreadsheet, and it will automatically create a formula to sum all the numbers in a continuous range. This function is a great way to speed up your financial analysis.
Where is the AutoSum button?If you need to sum a column or row of numbers, let Excel do the math for you with AutoSum. AutoSum is located on two tabs, the Home tab and the Formulas tab.
How you would use the AutoSum shortcut?AutoSum is a fast, easy way to add up multiple values in Excel. You can access the AutoSum command from either the Home tab or the Formulas tab, but there is a keyboard shortcut that makes it even faster: Alt+=. To use this shortcut, simply hold down the Alt key, then press the equals sign on your keyboard.
|