Quick, clean, and to the point

Autosum selected cells

Windows shortcut 
Mac shortcut 

If you select just the cells you'd like to sum, SUM formula(s) are placed below the selection. If you select empty cells to the right and Excel will place SUM to the right and SUM horizontally. If you select empty cells below and to the right, Excel will add SUM formulas to cells below and to the right.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll take a look at a few reasons why you shouldn't hardcode values that may change into your formulas.
In this lesson, we cover shortcuts you can use when working with Excel's functions.
In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.