In the previous article, I told you how to use the Excel **SUM** function to add multiple cell number values in the formula. In this article, I will tell you how to use a shortcut button ( **∑ AutoSum** button ) to summarize a column or a row of cell number values quickly, easily, and automatically.

### 1. How To Autosum A Column In Excel.

- Below are the example data cells.

- If you want to summarize column
**B**‘s number, you can select cell range**B2:B13**and then click the**Formulas**tab on the Excel top menu bar. - Then click the
**AutoSum**item (**∑**item ) in the**Function Library**group. - Then you will find it adds all the number values in the cell range
**B2:B13**and puts the number in cell**B14**automatically. - If you select cell
**B14**, you can find it adds the formula**=SUM(B2:B13)**in the cell automatically. - You can use the Excel Autosum function in another way.
- Click the cell
**C15**, then click the**Formulas**tab —> ∑**AutoSum**item in the**Function Library**group. - Then it will show a dotted box around the cells above cell
**C15**.

- If you confirm the cell range in the dotted box is correct, you can press the enter key to enter the formula in cell
**C15**. - Then you can see the column number summary in cell
**C15**also. **The Excel Autosum function will select and summarize the cells above ( not below ) the selected cell, and it will stop at the cell that contains a non-numeric value ( text, date, blank)**.- But you can adjust the selected cell range by dragging the dotted box corner square to include the non-numeric cells.
- When you drag the dotted box border to change the cell range, you can find the formula contained in cell
**C15**is changed accordingly. - If you want to summarize the 3 columns (columns
**B**,**C**,**D**) at the same time, you can select cell range**B2:D13**to select all the 3 columns at the same time. - Then click the
**Formulas**tab —>**∑ AutoSum**item to summarize all the 3 columns’ numbers and display the result in the last empty row.

- There is another method to auto-summarize the 3 column’s numbers at a time.
- Select the empty cell range
**B15:D15**, there are 3 cells in the range**B15**,**C15**, and**D15**. - Then click the
**Formulas**tab —>**∑ AutoSum**item, then it will summarize the 3 column numbers and put the result in cell range**B15:D15**.

### 2. How To Autosum A Row In Excel.

- Select the cell range
**B2:D2**in the above example row 2. - Then click the
**Formulas**tab —>**∑ AutoSum**item will summarize the above row numbers and put the result in cell**E2**. - You can use the above method to process each row of data one by one, but it is not efficient.
- There is another method to auto-summarize multiple rows of numbers easily.
- In this example, select the cell range
**B2:F15**and click the**Formulas**tab —>**∑ AutoSum**item. - Then it will summarize each row and column’s numbers automatically and put the result at the end of each row and column.
- It will also auto-summarize all the cell numbers in the cell range and put the result in cell
**F15**at the bottom right corner of the cell range.