SUMIF

Description

Use this function to return the sum of cells that meet a single condition. Supported in Chains.

SUMIF(range,criteria, [sum_range])

This function accepts the following arguments:

Name	Required	Description	Valid input
`range`	Yes	The range to be considered.	A cell, a cell range, or a formula which results in a cell range. A hard-coded value is also acceptable.
`criteria`	Yes	Additional numbers to be added.	A cell reference (including a range), a number, or a formula which results in either of these. A hard-coded value is also acceptable.
`[sum_range]`	No	The actual cells to be added, if you want to add cells other than those specified in `range`. If the `sum_range` argument is omitted, the cells that are added are those that are specified in `range`.	A cell, cell range, or a formula which results in a cell range. A hard-coded value is also acceptable.

Use case Formula Explanation and Result

Sum values in a range that meet a specific condition.

=SUMIF(A1:A5, ">50")

This formula works in the following manner:

SUMIF(: This is the function itself.
A1:A5: The range to evaluate against the criteria.
">50": The criteria. The function will sum cells in the range that are greater than 50.
The function finds 51, 93, and 75 in the range, ignoring text ("egg") and numbers not meeting the criteria (19).

For this data set, the formula returns 219.

Sum values in one range based on a condition in another range.

=SUMIF(A1:A5, ">=75", B1:B5)

This formula works in the following manner:

SUMIF(: This is the function itself.
A1:A5: The range to evaluate against the criteria.
">=75": The criteria.
B1:B5: The sum_range. The function sums values in this range *only* if the corresponding cell in the range meets the criteria.
It finds 93 (in A2) and 75 (in A5) meet the criteria, so it sums their corresponding values from column B: 39 + 22.

For this data set, the formula returns 61.

Sum values in one range, excluding those that meet a specific text criterion in another range.

=SUMIF(A1:A5, "<>egg", B1:B5)

This formula works in the following manner:

SUMIF(: This is the function itself.
A1:A5: The range to evaluate.
"<>egg": The criteria, meaning "not equal to 'egg'".
B1:B5: The sum_range.
The formula finds all cells in A1:A5 that are not "egg" (A1, A2, A4, A5) and sums their corresponding values from column B (56 + 39 + 92 + 22).

For this data set, the formula returns 209.

Notes

The sum_range value should have the same dimensions as the range provided in range. If it isn't, performance may suffer, and the formula will sum a range of cells that starts with the first cell in sum_range, but has the same dimensions as range.
SUMIF supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Criteria can be applied to dates, numbers, and text.
SUMIF can calculate sums based on cells that are blank ("") or not blank ("<>").
If text is included by a cell or range reference, then it is treated as a zero.
If text is included without quotation marks, the function returns a #NAME! error. If text is included with quotation marks, the function returns a #VALUE! error.
If arguments contain errors, SUMIF will return an error.
SUMIF can handle up to 255 total arguments.
SUMIF supports wildcards.

TBD