How to Sum Negative Numbers

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?


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?


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.


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.


=SUMIF(range, criteria, [sum_range])


– 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.

Leave a Reply