Sometimes you may need to add Negative Numbers in Excel. In this article, I will explain how to add Negative Numbers in Excel.
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.