How to Use AutoSum Function in Microsoft Excel?

Microsoft Excel is an app that can perform extensive calculations using a massive amount of data. While there are a variety of functions, its SUM function (short form of summation) is a commonly used one. It is one of the most basic functions of Excel. The automatic version of this function is known as AutoSum. This risewindows article will show you how to use the AutoSum function in Microsoft Excel. So, that topic is vast so we will see several topics about AutoSum.

Where is AutoSum in Excel?

The AutoSum button is available in 2 locations on the Microsoft Excel ribbon:-

Home > Editing > AutoSum, and

Formulas > Function Library > AutoSum.

How to do AutoSum in Excel?

If you have to do the sum of a single range of cells, columns, or rows, or several adjacent columns or rows, here the Excel AutoSum feature comes in handy, to sum up automatically.

Perform these 5 easy steps to use the AutoSum feature of Excel:-

Step 1. Firstly, select a blank cell next to the numbers where you want to store the sum’s values.

Step 2. To sum up,  a column, select the blank cell immediately below the column’s last value. Then, click on the AutoSum button from the Home or Formulas tab. The sum formula will automatically enter the selected blank cell, and the cell’s values will add, which will highlight.

Step 3. After that, press the Enter key from the keyboard to get the sum of the selected columns.

Quick Note: By default, it will select all columns upward if no blank cell is available in between.

Step 4. Next, select the blank cell to the right of the row’s last number, to sum up a row. Click on the AutoSum button from the Home or Formulas tab. The sum formula will automatically enter in the selected blank cell, and the cell’s values will add, which will highlight.

Step 5. Finally, press the Enter key from the keyboard to get the sum of the selected rows.

Quick Note: By default, it will select all rows to the left side of the selected cell if there is no blank cell available in between.

Bonus Tips: If there is a blank cell and Microsoft Excel does not select the desired rows or columns by default, after pressing the AutoSum button, you can select the desired cell to sum it.

Excel Sum shortcut

Those who prefer to use keyboard shortcuts rather than the mouse can hold the Alt and then press the = key to perform the AutoSum.

How to use AutoSum with other functions?

Apart from adding cells, Excel’s AutoSum button can insert other functions:-

AVERAGE – This function can return the average (arithmetic mean) numbers.

COUNT NUMBERS– You can use this function to count cells with numbers.

MAX – You can use this function to get the most significant number.

MIN – You can use this function to get the smallest value.

As usual, click on the blank cell where you want to get the desired result, click the AutoSum drop-down arrow, and choose the desired function from the list.

How to AutoSum only visible cells?

Till now, you have learned to AutoSum the values of rows or columns. But what will you do if you want to sum only visible cells from the filtered list?

You can always organize the tables in an Excel sheet by pressing the Ctrl + [/keybt]T[/keybt] shortcut. Once you organize the data and press AutoSum, it will insert the SUBTOTAL function by default instead of the SUM function. Only visible cells will add to the SUBTOTAL function, and those cells hidden by the filter method will ignore.

Excel AutoSum tips and tricks

If you want to sum values in several columns or rows at once, select all the cells where you want to insert the Sum formula, click the AutoSum button on the ribbon, or press the shortcut keys Alt + =.

For example, if you want to get the sum of columns in cells A9, B9, and C9, select A9, B9, and C9, then click AutoSum. The values in each of the 3 columns will sum individually.

Similarly, if you want to AutoSum of rows in columns E2, E3, E4, E5, E6, E7, and E8, select the E2, E3, E4, E5, E6, E7, and E8; click the AutoSum from Home or Formulas tab. You can also use the shortcut Alt and = keys.

That’s it for the article.

I hope this post will be informative to you.

Good luck & keep growing, guys.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: