27 April 2013
Excel 2007 and Excel 2010 offers some new functions that go beyond the simple SUMIF and COUNTIF as they allow you to test up to 127 conditions. The new functions are SUMIFS, COUNTIFS and AVERAGEIFS. (Excel 2003 does not offer AVERAGEIF but Excel 2007 does). They are called the plurals due to the S at the end of the function.
Full article: SUMIFS
