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
↑ Back to the top
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.
↑ Back to the top
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.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
↑ Back to the top