Summarizing Data Using New Functions


The Microsoft Excel 2007 programming team encourages users to suggest new capabilities that might be included in the future versions of the program. One of the most common requests from corporations using Excel was to find the average value of cells where the value met certain criteria. For example, in a table summarizing daily sales by department, a formula could summarize sales in the Housewares department for days in which the sales total was more than $10,000.

The Excel 2007 team responded to those requests by creating five new formulas that enable you to summarize worksheet data that meets a given condition. Here are quick descriptions of the new functions and any existing functions to which they're related:

  • AVERAGEIF enables you to find the average value of cells in a range for cells that meet a single criterion.

  • AVERAGEIFS enables you to find the average value of cells in a range for cells that meet multiple criteria.

  • SUMIFS, an extension of the SUMIF function, enables you to find the average value of cells in a range for cells that meet multiple criteria.

  • COUNTIFS, an extension of the COUNTIF function, enables you to count the number of cells in a range that meet multiple criteria.

  • IFERROR, an extension of the IF function, enables you to tell Excel 2007 what to do in case a cell's formula generates an error (as well as what to do if the formula works the way it's supposed to).




MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net