Share this article:

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.