Using Conditional Sum Wizard pg 230 231 232

14. Click Next. 15. After a while, the Conditional Sum Wizard Step 3 of 4 dialog box will appear.

Conditional Sum Wizard - Step 3 of 4			X

The Conditional Sum Wizard can copy the formula to your worksheet in two different forms.

Copy just the formula to a single cell.

		2

Copy the formula and conditional values.

		Gum X		1		2

	? Cancel	< Back		Next >		Finish

230

16. Select the option label Copy just the formula to a single cell. 17. Click Next. 18. After a while, the Conditional Sum Wizard appear. Step 4 of 4 dialog box will appear.
19. Under the label Type or select a cell and then click Finish, enter the cell address that you want the result to appear. 20. Click Finish. 21. You will see the result in the cell that you identified in step 19.

231

You will be able to see the formula in the formula bar. You will notice that the formula is preceded with "(" sign and ended with ")" sign. This indicates that the formula is an Array Formula. If you understand the mechanics of Array Formula, you don't have to use the Conditional Sum Wizard to build the formula.

If you edit the cell containing an Array Formula, the braces sign "[" and quotes ")" will disappear. To revert the formula to an array formula, press Ctrl, Shift and Enter keys simultaneously.


232