SUMIF

Sums values within a column if specified criteria is met

SUMIF( column, criteria )

Sums the values in a column that are within a row meeting the specified criteria

Arguments

Input	Description
column	Column to sum
criteria	Condition that must be met for values within column to be summed. criteria may reference the same or different column as column .

Output

Outputs sum of values in column that meet criteria

Example