# How to use the Conditional Sum Wizard in Excel

The Conditional Sum Wizard in Excel can be used to sum values based on multiple conditions. The Conditional Sum Wizard is a tool to help you in creating these more complex functions.

The Conditional Sum Wizard is an Excel add-in
and therefore it needs to be loaded first. To check if it has been loaded
already, click on the **Tools** menu. If
you cannot see it, it requires loading.

- Click the
**Tools**menu and select**Add-ins** - Select the
**Conditional Sum Wizard**from the list of available add-ins - Click
**Ok**

Suppose we are using the data below and need to calculate
the total orders by *James* for selling
*produce*.

## Using the Conditional Sum Wizard

- Click the
**Tools**menu and select**Conditional Sum**. The first step of the wizard is shown - Click in the box at the bottom and select the
range of cells you want to use including the column headings. In this example
that would be A1:E15. Click
**Next** - Step 2 of the wizard appears and is where you
specify the conditions of your sum. Select the column to sum from the first
list. In this example it is the
*Order Amount*column - Enter the conditions required and click the
**Add condition**button after each one to add them to the box at the bottom. Our example needs two conditions:*Salesperson = James*and*Category = Produce*. After entering the conditions click**Next** - Specify whether you want the wizard to input
just the result of the formula or the formula and the result in step 3 of the
wizard and click
**Next** -
Step 4 of the wizard is the final step. Select
the cell(s) where you want the result to appear and click
**Finish**

{=SUM(IF($A$2:$A$15="James",IF($D$2:$D$15=”Produce″,$E$2:$E$15,0),0))}

Excel enters an array formula when using the Conditional Sum Wizard. Array formulas can be recognised by the curly braces at each end. Find out more about how to write your own array formulas.

## Other Excel Array Formulas

The Excel Transpose function is used to switch data displayed in a row into a column and vice versa. It is the formula equivalent of the Transpose option found under Paste Special. The Paste Special option is useful if you want to perform a one time paste of the data.

A list of the most useful functions found in Excel and how to use them.

## More by this Author

- 5
If you are using Microsoft Project to schedule and track your projects, at some point you will probably want to export your project data into Excel. Excel can then be used to analyse and summarise your project data...

- 6
Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

- 0
Thinking of buying a basset hound puppy? Wondering what equipment you need in the house ready for the arrival of your new pet. This article will identify the 10 items you cannot be without to welcome home and care for a...

No comments yet.