Did you know that Excel SUM is the function that people read about most? To make sure, just check out Microsoft's list of 10 most popular Excel functions. No wonder they decided to add a special button to the Excel ribbon that inserts the SUM function automatically. So, if you wanted to know "What is AutoSum in Excel?
In essence, Excel AutoSum automatically enters a formula to sum numbers in your worksheet. For more details, check out the following sections of this tutorial. Whenever you need to sum a single range of cells, whether a column, row or several adjacent columns or rows, you can have Excel AutoSum to automatically make an appropriate SUM formula for you.
Click the AutoSum button on either the Home or Formulas tab. A Sum formula appears in the selected cell, and a range of cells you're adding gets highlighted B2:B6 in this example :. In most cases, Excel selects the correct range to total.
In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum. Now, you can see the calculated total in the cell, and the SUM formula in the formula bar:. If you one of those Excel users that prefer working with the keyboard rather than the mouse, you can use the following Excel AutoSum keyboard shortcut to total cells:. Pressing the Equal Sign key while holding the Alt key inserts a Sum formula in a selected cells s exactly like pressing the AutoSum button on the ribbon does, and then you hit the Enter key to complete the formula.
All you need to do is select a cell where you want to insert a formula, click the AutoSum drop-down arrow, and choose the desired function from the list. For example, this is how you can get the largest number in column B:. If you select More Functions from the AutoSum drop-down list, Microsoft Excel will open the Insert Function dialog box, like it does when you click the Insert Function button on the Formulas tab, or the fx button on the Formula bar.
You already know how to use AutoSum in Excel to total a column or row. Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen.
Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? If there is no value above, preceding cells in the row are checked and sum of the values is returned. This task can be done quickly using keyboard shortcut. And SUM function as described above is implemented on selected cell. Your email address will not be published.
Save my name, email, and website in this browser for the next time I comment.
0コメント