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.
Please remember that we may receive commissions when you click our links and make purchases