Know the anatomy of a SumIf to avoid Excel frustration

It’s important to know the anatomy of a SumIf to avoid Excel frustration. The first argument, “Range,” isn’t very clear. It means the range of cells you want to examine, not necessarily with what range you want to create a sum.

The criteria argument has its own quirks. Unless the criteria is that it equals a specific value or a value in a specific cell, your criteria goes quotes. It may seem strange to do that for greater than or less than criteria, but that’s the way it works. Sum_range is only needed if the range you’re adding is different than the range you’re examining.