**AutoSum in Excel** will help you to **SUM a Column or the Row which has Numbers**. **AutoSum in Excel** is a Perfect example which shows how Excel loves doing Math.

To **AutoSum**, make a selection of the Cell next to the Number that you wish to SUM.

In the **Home Tab**, **go to AutoSum**, **in its dropdown**, **select SUM** and **Press Enter**.

You’re good to go.

Once you’ve clicked on AutoSum, Excel automatically inserts a Formula in the Selected Cell. The Formula uses the SUM Function. *SUM Function helps to SUM the numbers*. If you found your results, then you can read this blog also. Strikethrough Shortcut in Microsoft Word & Excel

**What is AutoSum in Excel?**

**Example for AutoSum in Excel:**

**Situation:** *Column A contains the Dataset of TV Sold by USA, India, China, Japan and Russia. In front of it you have Column B, C, D for Jan Feb and March respectively*

**Problem 1)** *How will you find out the SUM of TV Sold by all the Countries in the Month of Jan?*

**Problem 2)** *How will you find out the Sum of TV Sold by India and China in the Month of Jan, Feb and March?*

**Solution 1: **To find out the SUM of TV Sold by all the Countries in the Month of Jan

**Autosum Errors you should avoid**

**Steps to avoid using autosum:**

- In the Cell B7, Type equals to sign ‘=’
- Select the Cells as ‘=B2+B3+B4+B5+B6’
- In the Cell B7, you get the answer for SUM product as 2,50,000

**✓ How to use Autosum Correctly ✓**

**Steps to do autosum in excel:**

- In the
**Cell B7**, Type**equals to sign ‘=’** - In the
**Home Tab**,**Go to Autosum**. In**Autosum drop down****select SUM**

**Press Enter**- You get the answer for your SUM product i.e.
**2,50,000**in our case

*Autosum in Excel will automatically calculate the SUM of the instructed row which had equals to sign.*

**How to sum multiple rows in excel?**

A faster way to add up the values in several cells or Columns in Excel is to follow these steps:

**Solution 2: **To find out the Sum of TV Sold by India and China in the Month of Jan, Feb and March:

**✖️ What you do? **✖️

** ****Steps to avoid doing sum of multiple rows in Excel: **

- For India, In the
**Cell E3**,**Type equals to sign ‘=’** **Select the cells as ‘=B3+C3+D3’**- You get the answer for
**SUM product as 1,65,000** - Then for the
**China**, In the**Cell E4**, Type**equals to sign ‘=’** **Select the cells as ‘=B4+C4+D4’**- You get the answer for
**SUM product as 1,50,000**

**✓ What you should do? ✓**

**Steps to sum of multiple rows in Excel:**

**Select**the Cell**India**,**China**and their Months i.e.**Jan, Feb and March**respectively till**Column E**- In the
**Home Tab**,**Go to Autosum**. In the**Autosum drop down****select SUM** **Press Enter**- You get the answer for your
**SUM product i.e. 1,65,000**and**1,50,000**in front of**India and China**respectively

With the given steps you’ll be able to **SUM Multiple rows and Columns using Autosum in Excel**.

*Autosum in Excel will automatically calculate the SUM of the instructed rows *

**Note:** We make the selection till **Column E** as we want the SUM of **China to appear in ****Column E**.

In this tutorial, you were able to see **how to SUM numbers in a Column** and **how to SUM Numbers of Multiple Columns using Autosum in Excel**.

**What is the definition of Autosum in Excel?**

In this Tutorial, you’ll learned about what is **Autosum in Excel** and **How to do Autosum in Excel**.

**Autosum in excel definition:**

What do you understand by the **Word Autosum**? It is a simple **Excel Function** in your **Spreadsheet**. **Autosum in excel definition** is, ‘An **Excel Function** which when used inserts a Formula in the Selected Cell. A **Function or Excel Formula** which helps to **SUM the numbers**. It adds the Numbers in the above Column. Not just this much, **Autosum in Excel** fix the range of Cells by looking at the Data above the selected Cell.

This approach to **adding up the cells**, **numbers in Columns and Rows** is interesting.

You just need to learn the right way to do **Autosum in Excel**.

Did you know we had an **AutoSum Excel Shortcut**?

**What is the ****Autosum Excel shortcut?**

**Autosum Excel shortcut is ALT.**

*Steps to Autosum Excel shortcut:*

**Select the Cell**next to the Number that you wish to SUM**Place the Cursor below the Column**or to the**left of the row of Numbers that you wish to SUM**- Press
**ALT equals to ‘=’**.**Hold the ALT****while pressing = sign** **Press Enter**