This is an excerpt from Pierre Leclerc (www.excel-vba.com)


Excel functions and formulas

The 2 Most Important

Excel Functions AND
Formulas

 

SUMPRODUCT

AND

INDEX/MATCH

 

 

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

 

left arrow Back Home