New in Excel 2007

The major improvements in Excel 2007 (see Table C-1) include the completely changed user interface and several new worksheet functions:

  • The logical functions now include the IFERROR() function that eliminates the need to nest the IF(ISERROR(...);...) functions.

  • The statistical functions include three new functions: AVERAGEIF(), AVERAGEIFS(), and COUNTIFS(). AVERAGEIF() and AVERAGEIFS() calculate the average using one or more filter conditions. COUNTIFS() complements COUNTIF() to allow number calculations based on more than one filter condition.

  • The math and trigonometry functions include one new function: SUMIFS() complements SUMIF() to allow summations based on more than one filter condition.

  • The cube functions category is new. ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial