The SUMIFS formula or function combines two of Excel's most popular functions - the SUM function and the IF function. What SUMIFS will do is sum up data in a range of cells when specific criteria are met in two or more ranges of data.
The tutorials listed below include examples of how to use the SUMIFS function in Excel 2007 and Excel 2010.
This step by step tutorial walks you through how to use the SUMIFS function in Excel. The tutorial includes screen captures and step by step instructions.
A text-only tutorial on the SUMIFS function intended for those familiar with using Excel's functions.