Microsoft Office Tutorials and References
In Depth Information
You can use the IFERROR function to display a custom error message, instead of relying
on the default Excel error messages to explain what happened. For example, you could
use an IFERROR formula when looking up the CustomerID value from cell G8 in the
Customers table by using the VLOOKUP function. One way to create such a formula is
=IFERROR(VLOOKUP(G8,Customers,2,false),”Customer not found”) . If the function finds
a match for the CustomerID in cell G8, it displays the customer’s name; if it doesn’t
find a match, it displays the text Customer not found .
See Also For more information about the VLOOKUP function, see “Looking Up Information in
a Worksheet” in Chapter 6, “Reordering and Summarizing Data.”
Just as the COUNTIF function counts the number of cells that meet a criterion and the
SUMIF function finds the total of values in cells that meet a criterion, the AVERAGEIF
function finds the average of values in cells that meet a criterion. To create a formula
using the AVERAGEIF function, you define the range to be examined for the criterion,
the criterion, and, if required, the range from which to draw the values. As an example,
consider a worksheet that lists each customer’s ID number, name, state, and total
monthly shipping bill.
If you want to find the average order of customers from the state of Washington
(abbreviated in the worksheet as WA), you can create the formula =AVERAGEIF(D3:D6,
”WA”, E3:E6) .