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
October 18th, 2008 at 11:01 pm
[...] the condition the cell equals “Mark”, and does this in cell D3: The easiest way is with Sumif, but here’s another just for [...]