Negative numbers are less than zero, such as -5, -15 etc. You can use the SUMIF function to have the sum of the negative numbers, or check here for positive numbers.
Example: You are working with a worksheet with the product in column A, the amount in column B, and the profit in column C.
Question : What is the Total of the Negative Numbers in Column C?
=SUMIF(C2:C10,"<0")
The result returns -$4,349.03. There are four negative numbers in column C: -$782.03, -$163, -$2,604, and -$800.
You can add up numbers in one column if a corresponding cell in another column is a negative number.
Question: What is the Total in Column B if the corresponding cells in Column C are Negative Numbers?
=SUMIF(C2:C10,"<0",B2:B10)
The result returns 2,578. There are four negative numbers in column C, and the corresponding cells in column B are B2, B5, B7 and B9.
Explanation:
The SUMIF function summarize the number of cells that meet one criterion, and "<0" filters the numbers less than zero. The quotation marks are necessary for the formula.
Notes: The SUMIF Function
The SUMIF function is to sum the values in a range that meet criteria that you specify.
Formula:
=SUMIF(range, criteria, [sum_range])
Explanations:
– Range is required; the range of cells that you want evaluated by criteria.
– Criteria is required; the criteria that defines which cells will be added.
