The SumIf function works perfect when you need to Sum a list by a certain criteria.

In this example we want to sum the list in cell A9 only for a name we type in cell A8

We can do this using the SumIf function. The basic SumIf syntax looks like this:

=SumIf(Range, Criteria, Sum Range)

So how do we do this?

1. In a cell where you want the sum to appear type =SumIf(
2. Click and drag the range to match against (A2:A6)
3. Type , (comma)
4. Type your criteria next. In this example we want to sum when our name in cell A8 is equal to a name in our range, so we type this “=” & A8
5. Type , (comma)
6. Click and drag the range to pull the sums from (B2:B6) and hit Enter