Summary. ...
Sum numbers in a range that meet supplied criteria.
The sum of values supplied.
=SUMIF (range, criteria, [sum_range])
range - The range of cells that you want to apply the criteria against. ...
When sum_range is omitted, the cells in range will be summed. ...
Microsoft SUMIF function documentation.