SUMIF
Adds the cells specified by a given criteria.
Syntax
SUMIF(range, criteria, sum_range)
Range is the range of cells you want evaluated.
Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, “>32”, “apples”.
Sum_range are the actual cells to sum.
Remarks
- The cells in sum_range are summed only if their corresponding cells in range match the criteria.
- If sum_range is omitted, the cells in range are summed.