What happened to the Conditional Sum Wizard add-in?

If you’ve looked for the Conditional Sum Wizard add-in and can’t find it, that’s because this add-in is not included with Excel 2013 and Excel 2016.

In Excel 2013 and Excel 2016, you can write conditional formulas by using functions that are designed to help with that task, such as the SUMIF and SUMIFSfunctions.

In earlier versions of Excel, you could use the Conditional Sum Wizard to help you write formulas that calculate the sums of values that met specified conditions. Formulas that were created by this Wizard will continue to work in Excel 2013 and Excel 2016.

You can still edit the formulas you created by using the Wizard directly in the formula bar or by selecting the formula cell and then clicking Formulas > Insert Function, which opens the Function Arguments dialog box.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.