Know the anatomy of a SumIf to avoid Excel frustration — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Know the anatomy of a SumIf to avoid Excel frustration

by on
in Excel Training,Office Technology

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.

Leave a Comment