SUMIF
Category: Mathematical Function.
Description: Sums the values in a range that meet criteria that you specify.
Syntax: SUMIF(range, criteria, sum_range)
Range is the range of cells that you wish to filter by criteria.
Criteria is a number, expression, cell reference, text, or function that defines which cells will be added.
Optional sum_range specifies the actual cells to add.
If omitted, the cells specified in the Range argument are added.