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:

Leave a Reply

Your email address will not be published. Required fields are marked *