Obtaining an Excel Sum (or Average, Count, Min, etc.) automatically is pretty easy. You no longer have to worry about entering in strings of cell references or clicking and dragging over the numbers you want to add. Using AutoSum is quick and easy and, it’s a great way to speed up simple Excel calculations. All you need is a column (or row) of numbers and you can get an Excel sum automatically.
Calculate an Excel Sum with AutoSum!
To start, you’ll need a column of numbers (a row of numbers works just as well), as in the picture below. Note that your column/row can be anywhere on your spreadsheet.
Then simply click on the cell at the bottom of your column (or at the end of your row). This will be the cell where your Excel Sum will be calculated. Once you’ve selected the proper cell, simply navigate up to the Home Tab. The AutoSum function is located on the far right-hand side of the Ribbon.
Simply click the AutoSum button, and your screen will look like this.
Excel automatically determines the cell range for you by including all of the adjacent cells directly above the cell you clicked on. It also gives you a visual representation of what the formula will include by highlighting the included cells with a dotted line. Simply press the Enter key to accept the formula and calculate the sum.
And you’re done! Not that if you want something other than an Excel Sum, simply click the drop down arrow next to the AutoSum button. Some of the more common choices include Average, Count, Min, Max, but you can use this technique with many more formulas.
Get even more free tips and tricks when you signup for our free email newsletter. You’ll receive free Excel tips and tricks directly in your inbox and also receive exclusive discounts to our upcoming training classes.