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.
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.
Pretty cool huh? Here is what the syntax looks like for the SUMIFS function:
* 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.