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.