Our expert trainers can help you get the best results.
If you would like any further information please contact one of our training advisors.
What is Excel AutoSum?
AutoSum is a tool in Excel that allows users to quickly calculate the SUM of data in their worksheet. The AutoSum button can be found in Home – Editing group, and also in Formulas – Function Library group.
If you click the little arrow on the right side of the AutoSum button you can access several other types of functions; AVERAGE, COUNT, MAX and MIN. Selecting one of these functions and an appropriate formula will be applied to your data.
How does AutoSum work?
Whilst a cell is active click the AutoSum button, Excel will then analyze the data surrounding the active cell; from this analysis it will propose a SUM formula. If the range proposed by Excel is correct then you can press Enter to accept and the formula is inserted. If Excel guessed your range incorrectly you and simply select the range to be summed and press Enter. Alternatively, press Esc to cancel.
AutoSum Tricks