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

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.

## align="center"Please check Page SUMIFS

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS ¦  COUNTIF  ¦  COUNTIFS  ¦  SUMIF  ¦  SUMIFS  ¦  IFERROR

Back Home