Subscriber only lesson.
Sign up to this course to view this lesson.
Discover how to use SUMIF function in a formula.
When to use
SUMIF combines SUM with IF to provide conditional summing, i.e. where you wish to add numerical values provided they meet a certain criterion.
- Adds the cells specified by a given criterion
- Syntax: SUMIF(range,criterion,sum_range)
- range is the range of cells that you want evaluated by criterion
- criterion is the single criterion in the form of a number, expression, or text that defines which cells will be added
- sum_range are the actual cells to add if their corresponding cells in range match criterion. If sum_range is omitted, the cells in range are both evaluated by criterion and added if they match criterion.
- The function SUMIF(Range,Criterion,Sum_range) is ideal for summing data based on one requirement:
- Range is the array that you wanted evaluated by the criterion (in this instance, cells B5:B16)
- Criterion is the criterion in the form of a number, expression, or text that defines which cell(s) will be added, e.g. G4
- Sum_range are the actual cells to be added if their corresponding cells in Range match the Criterion e.g. C5:C16
- So, to find the sales for Business Unit B in the above example, you can use the formula =SUMIF(B5:B16,G4,C5:C16) (which is $1,800)
Lesson notes are only available for subscribers.