SUMIF
Adds the cells specified by a given criteria
Syntax
SUMIF(range, criteria, [sum_range])
Parameters
- range: Required. The range of cells that you want evaluated by criteria
- criteria: Required. The criteria in the form of a number, expression, cell reference, text, or function
- sum_range: Optional. The actual cells to add. If omitted, the cells in range are used
Example
=SUMIF(A1:A10, ">5", B1:B10)