Page 232 - Excel Data Analysis

12 537547 Ch11.qxd 3/4/03 12:48 PM Page 218

EXCEL DATA ANALYSIS

USING THE CONDITIONAL

SUM WIZARD (CONTINUED)

ou have the option of pasting just the formula The final page of the wizard requests a cell reference for
created by the wizard into a cell in a worksheet, or pasting the created formula, which you can paste into any
Y you can paste the formula along with the values of cell. If you specified that you wanted to also paste the
each condition used to create the formula. For example, if condition values, Excel prompts you for the cell locations
you specified the following two conditions: for those values before the formula. The page displays
separately for each value that requires a cell reference.
Amount > $50,000.00
When you run the Conditional Sum Wizard, it creates a
State = Texas conditional formula using the SUM and IF functions and
places it in the specified cells. You can modify the formula
Excel gives you the option of pasting the values $50,000.00 at any time using the Function Arguments dialog box. See
and Texas in different cells in your worksheet. You can use Chapter 4 for more information on modifying formulas.
these conditional values as labels for the conditional sum
on your worksheet. On the third page of the Conditional Once you close the Conditional Sum Wizard, you cannot
Sum Wizard, you must specify whether you want to paste use it to modify the formula. If you run the wizard again,
the conditional values along with the formula. Excel assumes you want to create a new conditional sum
value.
Unfortunately, Excel does not allow you to select which
conditional values are pasted. You can either paste all
conditional values or only the conditional sum.
USING THE CONDITIONAL SUM WIZARD (CONTINUED)

■ The third page of the — Click the desired option. ■ The last page of the ™ Click Finish.
Conditional Sum Wizard Conditional Sum Wizard
displays, giving you the ± Click Next. displays. Note: If you opted to paste the
option of pasting only the condition values, Excel displays the
conditional formula in a cell ¡ Type the cell reference for final page separately for each
or pasting the formula and the formula. condition value.
each condition value in ■ You can click the Collapse
separate cells. button to select a cell from
the worksheet.
218