Page 231 - Excel Data Analysis

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

USING THE ANALYSIS TOOLPACK ADD-INS 11

When you create a conditional statement on the The Conditional Sum Wizard works well for data
second page of the Conditional Sum Wizard you lists where you have data records with the same
need to specify the conditional operator to use. values, for example, several sales amounts for the
The conditional operator you select determines state of Texas, or multiple computer hardware sales.
how Excel interprets the condition. For example, Using the common values in various data records,
you can use a comparison operator to specify a you can sum related cells quickly and paste the
conditional statement of: total amount in a cell.
If you do not have a relationship that you want to
Amount > $50,000.00
filter out within the data list, the Conditional Sum
Only the amounts that are greater than $50,000 Wizard is typically not the best tool for summing
and match the other conditions are summed. For columns. You should consider using the SUM
more on how to use comparison operators in function. See Chapter 4 for more information on
Excel, see Appendix D.
working with the SUM function.

Texas Amount

■ The second page of the ‡ Type the value for the ■ Excel adds the specified · Repeat steps 6 to 8 for
Conditional Sum Wizard condition or select a value condition to the box. each condition statement you
displays. from the selected column. want to create.
ˇ Select the column to sum. ° Click Add Condition. ‚ Click Next.
Á Select the condition
column and the conditional CONTINUED
operator.
217