Positive numbers are greater than zero, such as five, fifteen, etc., and negative numbers are less than zero, such as -5, -15, etc. Zeros separate the two groups. You can use the SUMIF function to have the sum of the zeros cells.

**Example:** You are working with a worksheet with the product in column A, the amount in column B, and the profit/loss in column C.

The sum of the cells that are zeros is zero. However, you may add up numbers in one column if a corresponding cell in another column is zero.

**Question: What is the Total in Column B if the corresponding cells in Column C are Zeros?**

=SUMIF(C2:C10,"=0",B2:B10)

=SUMIF(C2:C10,"0",B2:B10)

The result returns 800. There are two zeros in column C (C6 and C10), and the corresponding cells in column B are B6 and B10.

**Explanation:**

The SUMIF function summarizes the number of cells that meet one criterion, and "=0" filters the numbers that are zero in column C. The quotation marks are necessary for the formula, and the equal sign can be ignored.

**Notes: The SUMIF Function**

The SUMIF function sums the values in a range that meets the specified criteria.

**Formula:**

=SUMIF(range, criterion, [sum_range])

**Explanations:**

– Range is required; the cells you want to be evaluated by criteria.

– Criterion is required; the criteria define which cells will be added.