SUMIF

SUMIF(arg1, arg2, arg3) → { number | string | boolean }

Adds the cells specified by a given condition or criteria.

Parameters:

Name Type Description
arg1 ApiRange

Is the range of cells you want evaluated.

arg2 any

Is the condition or criteria in the form of a number, expression, or text that defines which cells will be added.

arg3 ApiRange

Are the actual cells to sum. If omitted, the cells in range are used.

Returns:

Type
number | string | boolean