# 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?

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