The function SUMIF returns the value of the addition of the cells from a selected range that meet a specific criterion.
Syntax:
=SumIf(value or range of cells, criteria)
Values or Range of cells. List of values or reference to a range of cells to add up.
Criteria. Condition to determine what values to add up, can be a reference to a cell for dynamic criteria.