When and How to Use the SUMIF Function in Excel

BizNet Quick Tips:

When and How to Use the SUMIF Function in Excel

The SUMIF function is an incredibly useful and time-saving tool available to all Excel users. Best of all, it’s so easy to use.

SUMIF(range, criteria)

This allows you to add up the sum of cells that meet specific criteria. To show this, we’re going to use a very basic example.

You manage a sales team of five people. Each person’s individual goal is to sell $65,000 in balls, giving you a total goal of $333,000. You can use the SUMIF function to see if your team reached the goal. In this example, you can see that between your five sales team members, the total ball sales over $65,000 were $210,000, which means some members met the goal while others did not.

Range: This is required. This is the range of cells that you want to be evaluated by criteria.

Criteria: This is also required. It is the criteria in the form of a number, expression, cell reference, text or a function that defines which cells will be added. For example, this can be 50, “<35”, C7, “balls” or TODAY().

BizInsight, which works directly in Excel, has already helped thousands of people in industries from manufacturing and distribution to nonprofit and finance save time reporting. Combine these Excel tricks with BizInsight and you’ll have more hours in the day than you’ll know what to do with. Learn more about the standalone product here.