To return to the previous section of this article, click Run the Conditional Sum Wizard

In step 2 of the wizard, you specified a single condition for your total, Region=South. What if you have more than one condition, such as totaling beverage sales for November? The wizard makes this just as easy:

1. Repeat steps 1 through 5 above: run the wizard and select the entire range of data.
2. For the first condition in step 2 of the wizard, sales of beverages, click Product in the Column box, click Beverages in the This value box, and then click Add Condition, so that the dialog box looks like this:

   

   To specify the second condition, click Month in the Column box, click Nov in the This value box, and then click Add Condition again:

   

3. Click Next twice, specify cell D15 for the result, and then click Finish. The resulting formula adds the sales from rows 5 and 8 and looks like this:

   

Next: How the conditional formulas work