The SUMIF function sum values from a range of cells using a condition. In simple words, it sum numbers from a range which meets specific criteria.
You need to define a range to check for criteria and a corresponding range of values which you want to sum.
SUMIF(range, criteria, [sum_range])
- range A range of cells from which you want to check for criteria.
- criteria A criteria which can be a number, text, expression, cell reference or a function.
- [sum_range] A cell range which has the values you want to sum.
In the below example, we have specified A1:A9 as criteria range and B1:B9 as sum range. After that, we have specified the criteria in A12 which has the value C.
You can also insert criteria directly into the function.
And, if you skip specifying the sum range it will give you the sum of criteria range. But, that will be only possible if criteria range has numeric values.