In our first post, we looked at the power of SumIf’s. Here, we will look at another way to summarize the same data, but by location code.

We add our three location codes from the data above in Col. A. In Col. B the formula “**=SUMIF($A$2:$A$37,A41,$B$2:$B$37)**“. In this example, cell A41 has our location code “001”. Copy/paste the formula. We add a total to check against the sum of all data.