SUMIF Function Explained
The SUMIF Function in Microsoft Excel is used to sum up values in a range of cells that meet a certain criteria. It takes three arguments: the range of cells to sum, the criteria range, and the criteria. The function will then sum up all the values in the range that meet the criteria.
SUMIF Function Syntax
SUMIF(range, criteria, [sum_range])
- range: The range of cells that you want to apply the criteria against.
- criteria: The criteria in the form of a number, expression, cell reference, or text that defines which cells will be added.
- sum_range: (optional) The actual cells to sum. If omitted, range is used.