Saturday, 2 February 2013

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:

No comments:

Post a Comment