From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Extending the capabilities of AutoSum

Extending the capabilities of AutoSum

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Extending the capabilities of AutoSum

“

- Probably the most commonly used function in Excel SUM, sum. Add up the numbers. There's also a button called AutoSum, on the right side of the Home tab you'll see AutoSum. Notice there's a drop arrow to the right of it. Click it, you'll see some other choices as well. The AutoSum button is also found on the Formulas tab in the ribbon, left side, also a drop arrow there. The AutoSum button, the AutoSum capability, is designed to add numbers from above or from the left. A typical example would be in cell G2. We want a total from the left to the right. We can use that button, or as we slide over the button, notice it's got a keystroke shortcut, Alt =. Either one is going to work here. I'll press Alt =, we see what Excel is about to do. It's about to add up those numbers, we'll simply press Enter. Let me undo that with Control Z, if you use the button, you can click on it. Ultimately the same effect. You can press Enter or click the button again. And that suggests, why not just double…

Contents