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.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34715/know-the-anatomy-of-a-sumif-to-avoid-excel-frustration "