Sometimes you may need to **add Negative Numbers in Excel**. In this article, I will explain** how to add Negative Numbers in Excel.**

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here:

## 4 Methods to Add Negative Numbers in Excel

Here, I’m going to explain **4** methods of **how to add Negative Numbers in Excel.** For your better understanding, I will use a sample dataset. Which has** 2 Columns**. Those are **Categories **and **Expenses**. The sample dataset is given below.

### 1. Use of SUMIF Function to Add Negative Numbers in Excel

You can use **the SUMIF function** **to add Negative Numbers in Excel. **The steps are given below.

**Steps:**

- Firstly, you have to select a different cell
**C11**where you want to see the result. - Secondly, you should use the corresponding formula in the
**C11**cell.

`=SUMIF(C5:C10,"<0",C5:C10)`

**Formula Breakdown**

Here, the **SUMIF **function will sum up all the numbers which fulfill a given condition.

- Firstly, the
**C5:C10**denotes the data range in which the criteria will be present. - Secondly,
**<0**denotes the**criteria**. This means it will sum up all those numbers which are**negative**or less than**0**.*Here, when you use any criteria without selecting the cell value then you must use the***Inverted Comma.** - Finally,
**C5:C10**denotes the data range which to add.

- Subsequently, you must press
**ENTER**to get the result.

Finally, you will see the **added Negative Number**.

**Read More: ****Excel Formula to Return Zero If Negative Value is Found**

### 2. Applying AutoSum Feature for Adding Negative Numbers

You can apply **the AutoSum feature** to** add Negative Numbers **in Excel. Actually, under this feature, there are some functions and **the SUM function** is one of them. The steps are given below.

**Steps:**

- Firstly, you have to select the cell where you want to keep the added value. Here, I have selected the
**C11**cell. - Secondly, from the
**Home**tab >> you should go to the**Editing**command. - Thirdly, from the
**AutoSum**>> you should choose the**SUM**feature.

- Now, you have to select the data range which you want to sum up. As you can see, Excel auto-selects my data range.

Finally, you will see the **added Negative Number**.

**Read More: ****[Fixed!] Excel Not Adding Negative Numbers Correctly (4 Solutions)**

### 3. Employing Format Cells Command and SUM Function

Here, I will format the data for **Negative Numbers** using the **Format Cells **command. Then, I will use the **SUM** function to** add Negative Numbers in Excel.** The steps are given below.

**Steps:**

- Firstly, you have to select the data range. Here, I have selected
**C5:C10**.

- Now, you need to press the
**CTRL+1**keys to open the**Format Cells**dialog box directly.

Also, you can use the **Context Menu Bar** or the **Custom Ribbon** to go to the** Format Cells **command. *In the case of using the Context Menu Bar, select the data range >> Right-Click on the data >> choose the Format Cells option.*

*In the case of using Custom Ribbon, select the data range >> from the Home tab >> go to the Format feature >> choose the Format Cells command.*

After that, a dialog box named** Format Cells **will appear.

- Now, from that dialog box, you have to make sure that you are on the
**Number**command. - Then, go to the
**Currency**option.*Here, as I want to keep the***dollar**sign for monetary values, that’s why I have used the**Currency**format for my data range. - After that, from the
**Negative numbers:**option >> choose your preferred style. Here, I have chosen the**2nd**style. - Finally, you have to press
**OK**to get the changes.

When you want to keep the data as numbers only, then you can use the **Number** format.

- In that case, go to the
**Number**option. - After that, from the
**Negative numbers:**option >> choose your preferred style. - Finally, you have to press
**OK**to get the changes.

At this time, you will see the following situation.

- Now, you have to select a different cell
**C11**where you want to keep the result. - Then, you should use the corresponding formula in the
**C11**cell.

`=SUM(C5:C10)`

Here, the **SUM **function will sum up all the numbers. And **C5:C10** denotes the data range which to add.

- Subsequently, you must press
**ENTER**to get the result.

Finally, you will see the **added Negative Number**.

**Read More: ****How to Put a Negative Number in Excel Formula (4 Easy Methods)**

### 4. Generic Formula to Add Negative Numbers in Excel

Also, you can use a generic formula **to add Negative Numbers in Excel. **The steps are given below.

**Steps:**

- Firstly, you have to select a different cell
**C11**where you want to keep the result. - Secondly, you should use the corresponding formula in the
**C11**cell.

`=C5+C6+C7+C8+C9+C10`

Here, I have added the cell values using the** Plus (+)** sign.

- Finally, you must press
**ENTER**to get the result.

At this time, you will see the **added Negative Number**.

**Read More: ****How to Show Negative Numbers in Excel (4 Quick Tricks)**

## 💬 Things to Remember

- The generic
**formula**is the manual process. So, you should try to not use**method-4**. - Furthermore, when there are
**both positive and negative numbers**in your data range and you want to add only the negative numbers in that case you should use the**SUMIF**function or**method-1**. - On the other hand, when you have
**only negative numbers**in your data range to add those values you can use either**method-2**or**method-3**.

## Practice Section

Now, you can practice the explained method by yourself.

## Conclusion

I hope you found this article helpful. Here, I have explained **4 Methods to Add Negative Numbers in Excel.** You can visit our website **Exceldemy** to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.