What it does: The SUMIF() Functions sum together values based on criteria you provide.
Plain English: The SUMIF() formula is like the SUM() formula on steroids. Without having to make a Pivot Table or get too complicated, SUMIF() allows you to attach criteria to your SUM() formula, only totaling the data you need to use.
- Sum Sales totals greater than $1,000
- Sum video view totals only on videos about skateboarding
- Sum sales totals over the last 5 years only if they occurred in Q4.
Arguments: SUMIF(range, criteria, [sum range])
- Range – The range you want to check for a certain criteria, ie “skate video” or not skate video
- Criteria – The criteria you want, ie “Skate Video”
- Sum Range – The column in which the data resides that you want to sum. In the case of the skate video views, it would probably be the “views” column.