Use of SUMIF Function
If you have some positive numbers and negative numbers in the list, then with SUMIF function we can sum only positive or only negative numbers. You can only easily do 2 steps.
1. Selecting Range
2. Apply more than and less than conditions.
= SUMIF(Range,Condtion)
Let’s understand from an example.
1. Sum of Positive Numbers Only (Sum of More than Zero)
The balances are given in column F in the list below. Positive and negative numbers are given in the list.
For the sum of Negative number, type in the cell
=SUMIF(
When the range is highlighted, select the cell in the column that contains the number and give a comma.
Close the bracket by typing “> 0” in the Criteria. Press Enter.
=SUMIF(F3:F7,”>0″)
2. Sum of Negative Numbers Only – (Sum of Less than Zero)
Just like the total of positive numbers, the symbol for negative space is to be changed only for negative numbers.
For the sum of the Negative number, Type in the cell
=SUMIF(
When the range is highlighted, select the cell in the column that contains the number and give a comma.
Type a bracket by typing “<0” in the Criteria. Press Enter.
=SUMIF(F3:F7,”<0″)
