The Microsoft Excel programming team encourages users to suggest new capabilities that could be included in future versions of the program. Apparently, one of the most common requests from corporations using Excel was to find the average value of cells in which the value met certain criteria. For example, in a table listing orders, a formula could find the average amount of all orders over $1,000.
Here are quick descriptions of the new functions and any existing functions to which they’re related. The following figure shows these functions in action, and lists the exact formula used to calculate the cell’s values:
AVERAGEIF, which lets you find the average value of cells in a range for cells that meet a single criterion
AVERAGEIFS, which 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, which enables you to find the sum of cells in a range for cells that meet multiple criteria
COUNTIFS, an extension of the COUNTIF function, which enables you to count the number of cells in a range that meet multiple criteria
IFERROR, an extension of the IF function, which lets you tell Excel what to do in case a cell’s formula generates an error (as well as what to do if the formula works as expected)
18.118.253.55