|
Excel Chapter 20A of 24: SUMIF FunctionThe SUMIF Function The general format for the SUMIF formula is as follow: =SUMIF(range where criteria applies, criteria, sum what)
The SUMIF function is limited to one criteria (one column). 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 with "or" or "and" ...SUMPRODUCT is like SUMIF on steroids. |
Next Chapter: Statistical Functions and Formulas in Excel |
|
Excel SUMIF Function