Saturday, March 3, 2012

Excel Tips (Sumif Function)


In this video I am going to teach you how to use sumif() function to add all numbers in a range of cells based on a given criteria.
The syntax of SumIf function is:
  • sumif( range, criteria, sum_range )
  • range is the range of cells which you want to apply in the given criteria
  • criteria is used to determine which cells to be add in range
  • sum_range are the range of cells to be sum