The 2 Most Important
Excel Functions AND
Lesson 15:New functions in Excel 2007
In 2007 Microsoft has added 5 new functions to Excel. If you use any of these functions and send the resulting workbooks to colleagues who are usiing Excel 1997 to 2006, the new functions will not work.
There has always been an extremely powerful and easy to use function in Excel that can do anything that can be done with 4 of the new functions (SUMIFS, COUNTIFS, AVERAGEIF, AVERAGEIFS). As a matter of fact you can do even more than with any of the new functions with SUMPRODUCT.
As for the 5th new function (IFERROR), you can do the same thing combining two old and friendly functions IF and ISERROR.
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIF ¦ COUNTIFS ¦ SUMIF ¦ SUMIFS ¦ IFERROR