Microsoft KB Archive/817775

= Error message when you run the Conditional Sum Wizard in Excel =

Article ID: 817775

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-





SYMPTOMS
When you try to use the Conditional Sum Wizard to enter a formula, you may receive the following error message:

Run-time error '1004':

Unable to set the FormulaArray property of the Range class



CAUSE
This problem occurs if you enter a condition in the Conditional Sum Wizard that contains a value that is not contained in the selected cell range.



WORKAROUND
To work around this problem, use the Conditional Sum Wizard to enter a formula that contains a value that is in the selected cell range, and then manually change the inserted formula to match the conditions that you want.

Note After the Conditional Sum Wizard has inserted the formula, click the cell that contains the formula. In the Formula bar, modify the formula to match the conditions that you want, and then press CTRL+SHIFT+ENTER to accept the changes that you made.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2002

Keywords: kberrmsg kbprb KB817775

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.