Excel Hangout: How to use a simple SUMIF function Technique: How to use a simple SUMIF function | Why: Add values from a table that match your criteria | Step 1: Create or import a list of items | Step 2: Use the SUMIF formula to add values using a matching criteria Buy $4.99