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.

**A****B****C****D****E****1**iOS Android Windows **2**Jan 99 80 18 **3**Feb 89 76 25 **4**Mar 92 79 36 **5**Apr 86 82 28 **6**May 85 76 19 **7**Jun 87 67 21 **8**Jul 92 83 19 **9**Aug 99 80 17 **10**Sep 91 90 35 **11**Oct 80 86 27 **12**Nov 78 67 37 **13**Dec 82 68 57 **14**1060 **15** - If you want to summarize column
**B**‘s number, you can select cell range**B2:B13**and then click the**Formulas**tab on 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 put 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 which 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 also. - 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.

**A****B****C****D****E****1**iOS Android Windows **2**Jan 99 80 18 **3**Feb 89 76 25 **4**Mar 92 79 36 **5**Apr 86 82 28 **6**May 85 76 19 **7**Jun 87 67 21 **8**Jul 92 83 19 **9**Aug 99 80 17 **10**Sep 91 90 35 **11**Oct 80 86 27 **12**Nov 78 67 37 **13**Dec 82 68 57 **14**1060 934 339 **15** - 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’s 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.

**A****B****C****D****E****F****1**iOS Android Windows **2**Jan 99 80 18 197 **3**Feb 89 76 25 190 **4**Mar 92 79 36 207 **5**Apr 86 82 28 196 **6**May 85 76 19 180 **7**Jun 87 67 21 175 **8**Jul 92 83 19 194 **9**Aug 99 80 17 196 **10**Sep 91 90 35 216 **11**Oct 80 86 27 193 **12**Nov 78 67 37 182 **13**Dec 82 68 57 207 **14****15**1060 934 339 2333