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.
1. Excel 2007 SUMIFS Function Tutorial
Excel SUMIFS Function Tutorials
This step by step tutorial walks you through how to use the SUMIFS function in Excel 2007. This tutorial includes an example of how to use the SUMIFS function in Excel 2007.
2. Excel 2010 SUMIFS Function Tutorial
Excel SUMIFS Function Tutorials
This step by step tutorial walks you through how to use the SUMIFS function in Excel 2010. This tutorial includes an example of how to use the SUMIFS function in Excel 2010.
