Conditional sum wizard alternatives

The provided text explains how to use the Conditional Sum Wizard to sum values based on multiple conditions, a feature that was removed starting in Excel 2010. The page specifically demonstrates how to sum a QTY column when the MTH column equals 1 and the ITEM PURCHASED column equals 'Gum X'.

Modern Alternatives in Excel

Since the wizard is obsolete, you can achieve the exact same result using newer, more efficient functions.

1. The SUMIFS Function (Recommended)

This is the standard and easiest way to sum data using multiple criteria.

=SUMIFS(QTY_Range, MTH_Range, 1, ITEM_PURCHASED_Range, "Gum X")
• QTY_Range: The column you want to total.
• MTH_Range: The column checked for the month value 1.
• ITEM_PURCHASED_Range: The column checked for the text "Gum X".

2. The SUMPRODUCT Array Function

If you want to use an array formula approach as the textbook chapter intends: =SUMPRODUCT((MTH_Range=1) * (ITEM_PURCHASED_Range="Gum X") * QTY_Range)

Direct Comparison

Method				Requires Ctrl+Shift+Enter?	Efficiency		Setup Difficulty
SUMIFS				No							Extremely Fast	Very Easy
SUMPRODUCT			No							Fast			Moderate
Old Wizard Array	Yes (in old Excel)			Slower			Hard