How to Sum Cells are Zeros

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.

Leave a Reply