Microsoft Office Tutorials and References

In Depth Information

3.
In cell
I3
, type the formula
=AVERAGEIF(C3:C14, “=Box”, F3:F14)
, and press Enter.

The value
$46,102.50
, which represents the average cost per category of boxes,

appears in cell I3.

4.
In cell
I6
, type
=SUMIFS(F3:F14, C3:C14, “=Envelope”, E3:E14,

“=International”)
.

The value
$45,753.00
, which represents the total cost of all envelopes used for

international shipments, appears in cell I6.

CLEAN UP
Save the PackagingCosts workbook, and then close it.

Finding and Correcting Errors in Calculations

Including calculations in a worksheet gives you valuable answers to questions about your

data. As is always true, however, it is possible for errors to creep into your formulas. With

Excel, you can find the source of errors in your formulas by identifying the cells used in a

given calculation and describing any errors that have occurred. The process of examining

a worksheet for errors is referred to as
auditing
.

Excel identifies errors in several ways. The first way is to display an error code in the cell

holding the formula generating the error.