**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.

Examples:

- 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.