Tag Archives: SUMIF

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: