Sign In


Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!



Add Only Cells that Meet Certain Criteria with SUMIF in Excel


This video will help you to add only certain items from a range (table) based on criteria found in the same row. The syntax for the SUMIF formula is =SUMIF(range, criteria, [sum range])

Sum range is optional and is only used if the range that you want to add is different than the range you are checking.

Tutor Bio

Alternative Text

In real life Mike is a husband and father of 2. He also develops websites (like this one) and makes overwhelming amounts of data understandable using Excel, Numbers, Access, etc.