How to use SUMIF()-function

Excel's SUMIF()-function is handy function for summing items matching specified criteria.
The syntax of the SUMIF is

SUMIF(range, criteria, [sum_range])

• range: range of the cells to apply the criteria against
• criteria: determines which cells to add
• sum_range: this is optional parameter specifying which cells to sum. If omitted, the range is used as the sum_range

Following video demonstrates the usage of SUMIF: