Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!
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.
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.