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: