#369 Conditional Calculations with SUMIF & COUNTIF

If you use Excel you probably know about the SUM and COUNT functions. If you’re ready to go a step further you should also know about a couple of simple and very useful variations of those — SUMIF and COUNTIF.

It’s fast and easy to get basic totals using the SUM function. But how do you get a total for only for cells that meet certain criteria? Of course, you could manually create formulas pointing to each cell you want to include – but you are way too smart for that, right?

With the SUMIF function you can easily look for a specific value in column A and then only add the corresponding values in column B when it meets your criteria.

For example, let’s see how easy it is to use SUMIF to find the sum of the sales in the East region.

Syntax: =SUMIF(range, criteria, sum range)

Result = $16,257

Similarly, let’s see how COUNTIF can tell us how many entries there are for the East region.

Syntax:  =COUNTIF(range, criteria)

Result = 3

You can also use AVERAGEIF in the same way as these. Check it out in this video.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s