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.
