# 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.

2. Select the Conditional Sum Wizard from the list of available add-ins
3. Click Ok

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

Data to be used in the conditional sum

## Using the Conditional Sum Wizard

1. Click the Tools menu and select Conditional Sum. The first step of the wizard is shown
2. 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
3. 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
4. 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
5. 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
6. 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

Transpose Function

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.

Microsoft Excel Functions

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

## More by this Author

• 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

If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

• 10

Impaction is when a bearded dragon’s digestive tract has become blocked. It is a very real hazard that is brought about when the beardie has either swallowed something that is too large, or something that it...

0 of 8192 characters used

Alan Murray (almurray)57 Followers
71 Articles