#321 New SUMIFS Excel Function

We’ve seen how easy it is to sum and/or count values based on some specific criteria using the SUMIF and COUNTIF functions. For example, summing the sales for the West region or counting the number of orders for a particular salesperson is easily handled that way.

Data

Easily getting Phil’s total amount  =SUMIF(B2:B22,”Phil”,C2:C22)  and a count of the West region  =COUNTIF(A2:A22,”West”)  is a great trick to have up your sleeve, but it only works for a single condition. What if you want to easily find out how much Phil sold in the West region?? This is where the (relatively) new SUMIFS and COUNTIFs functions come to our rescue.

IFS2

Pretty cool huh? Here is what the syntax looks like for the SUMIFS function:

syntax

Interested in learning more? Grab a file to practice with or check out these step-by-step tutorials on SUMIFSCOUNTIFS and AVERAGEIFS

* Note that there is one very minor catch. These functions only work in Excel 2007 or later. So just be aware of that if you send your files to anyone still using an older version of Excel.

Advertisements

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