AutoSum in Excel

AutoSum in Excel

17 January 2022 0 Door Bjorn Meijer

If you regularly work with Excel, it often happens that you have to add columns or rows of numbers. And this can be done in Excel in different ways. One of these ways is with the AutoSum function. Thanks to this function, you avoid mistakes and it also saves time!
In this blog I will show you how you can add numbers in Excel in different ways. We'll start with the most time-consuming way and move on to a faster way.

Add numbers separately

We take a sequence of random numbers in the range A1:A9† in cell A10 it wants to display the total of this range. I'm going to jail A10 and enter the following formula here:
=A1+A2+A3+A4+A5+A6+A7+A8+A9 and then press Enter† Cell A10 then contains the total of the range A1:A10 displayed.

Excel - adding numbers

Add numbers with the SUM() function

If you have a lot of numbers or are lazy like me, the above method is a time-consuming job. In addition, the chance of errors also increases. We delete the formula in cell A10 and go again the numbers from the range A1:A9 add up. Select cell A10 select and enter the formula =SUM(A1:A9) in. You can type the formula manually, but you can also choose to =SUM( and then use the mouse to select the range A1:A9 to select. End the formula with ) and press Enter.

Excel - sum numbers with SUM() function

Adding numbers with the AutoSum . function

Excel is an extremely smart program and can estimate quite well what the user wants. We delete the formula in cell again A10 and look for an even faster way of adding. This time we will use the AutoSum button.
In the Ribbon, go to the Tab Start Group To process and click the button AutoSum.
Excel now automatically fills the formula =SUM(A1:A9) in and all you have to do is click Enter to display the result of the sum.

Excel - sum numbers with function AutoSum

Do you want to add multiple columns separately (For example in the range A1:M9† Then select the range A1:M10 and click the AutoSum button. All columns are then added separately.

Excel - sum multiple columns with AutoSum

Addition with the key combination Alt+=

The AutoSum button already works a lot faster than the first two ways. Can it be even faster? Yes, of course! For this we use the key combination Alt+=. Delete in cell A10 the current formula. Then press the key combination Alt+= and the formula =SUM(A1:A9) is automatically filled in. Press Enter and the result is immediately visible.

Excel - add numbers with key combination Alt+=

Do you want to add multiple columns separately (For example in the range A1:M9† Then select the range A1:M10 and then press the key combination Alt+=. All columns are then added separately.

Add columns and rows

Do you want to sum both the rows (vertical) and the columns (horizontal)? Then select the cells below and next to the range you want to sum. Then press the key combination Alt+= and both the rows and the columns are summed.

Excel - Sum rows and columns with Alt+=