

Special Excel Functions 20032010
Special Excel Functions 20072010

Lesson 15: SUMIF Function in Excel
The general format for the SUMIF formula is as follows: =SUMIF(range where criteria applies, criteria, sum what). In this first example the criteria applies to the range that is summed: The criteria can also be in another column. Applied to the table above, the result of the following formula should be 14: If you want to sum the amounts based on month, State AND name, discover the very simple SUMPRODUCT function with which you can use 2, 3 or more criteria. Excel Functions and Formulas Sitemap Go to the next lesson:


