Sometimes you may need to add Negative Numbers in Excel. In this article, I will explain how to add Negative Numbers in Excel.
Here, I’m going to explain 4 methods of how to add Negative Numbers in Excel. However, you can sum both negative and positive numbers in Excel too. 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. Using the 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
3. Use of Format Cells Command and SUM Function to Add Negative Numbers in Excel
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. 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
💬 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.
Download Practice Workbook
You can download the practice workbook from here:
Conclusion
I hope you found this article helpful. Here, I have explained 4 Methods to Add Negative Numbers in Excel. Please, drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Add Brackets to Negative Numbers in Excel
- How to Change Positive Numbers to Negative in Excel
- Excel Negative Numbers in Brackets and Red
- How to Apply Formula for Positive and Negative Numbers in Excel
- How to Count Negative Numbers in Excel
- How to Make a Group of Cells Negative in Excel
- How to Show Negative Numbers in Excel
- How to Make Negative Numbers Red in Excel
- How to Convert Negative Value to Positive in Excel Using Formula
- Excel Formula If Cell Contains Negative Number
- Excel Formula to Return Blank If Cell Value Is Negative