Page 151 - Excel Workbook for Dummies

14_798452 ch09.qxp 3/13/06 7:52 PM Page 134
134 Part II: Using Formulas and Functions
If you were to select the Copy Formula and Conditional Values, the Wizard would
then prompt you for cell references for each column used in a condition and its
associated SUMIF formula.
11. In the Step 4 of 4 Conditional Sum Wizard dialog box, click cell I10 in the work-
sheet to insert the reference ‘Jan-06 Sales’!$I$10 in its text box and then select
the Finish button.
Excel then inserts a long SUM function containing several nested IF conditions in
cell I10.
12. Open the Solved9-5.xls workbook in your Chapter 9 folder inside the My Practice
Spreadsheets folder and then check the SUMIF formulas and SUM formula with
nested IF functions in your workbook against those found in this workbook file.
If everything checks out OK, save your workbook under the name Solved9-5-
mine.xls and then close both the workbook files as you exit Excel.

Figure 9-4:
The Step
2 of 4
Conditional
Sum Wizard
dialog box
after speci-
fying the
column to
sum and the
conditions
to use.