Error message when you run the Conditional Sum Wizard in Excel (817775)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002

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 "Applies to" section.
Modification Type:MajorLast Reviewed:7/23/2004
Keywords:kberrmsg kbprb KB817775
©2004 Microsoft Corporation. All rights reserved.