Re: Array Formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hopefully someone more knowledgeable about this stuff will come along to help you; however, that formula appears to work correctly on my system. I'm not sure if this will help you to focus in on the problem or not; but I do note that the original error message you reported, namely...

"Run-time error "1004": unable to set the
FormulaArray property of the Range class"

looks like a VBA error message (from, say, a macro or UserForm code module) and not a work*** error message. Do you have any VBA code running that is trying to set a FormulaArray property of a range (perhaps one that is overlapping the cell(s) you are putting your formula into)?

Rick


"sharon t" <sharont@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A3DF7124-64A5-487C-AAB9-DBDE71ECCBE5@xxxxxxxxxxxxxxxx
=SUM(IF('Grand Total-All Detail'!$B$3:$B$14="Jane",IF('Grand Total-All
Detail'!$A$3:$A$14="Doe",IF('Grand Total-All Detail'!$C$3:$C$14=2007,'Grand
Total-All Detail'!$L$3:$L$14,0),0),0))

The "Grand Total-All Detail" is one of many spreadsheets in the workbook and
am writing the array formula in another "summary" spread***. It will work
if I enter on same spread*** but don't want it there. Have always been able
to write this formula to show summaries on a separate spread*** within the
same workbook.

"Rick Rothstein (MVP - VB)" wrote:

It might help if you show us your code

Rick


"sharon t" <sharont@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E29EC74E-5394-481E-9EDB-86153DCEC18D@xxxxxxxxxxxxxxxx
>I am receiving a Run-time error "1004": unable to set the FormulaArray
> property of the Range class.
>
> Stated fix is to install SP2. I have SP3 installed. Does anyone know if
> SP3
> included that fix that was in SP2? If so, why am I still receiving the
> error
> and the formula does not work correctly. Thanks.



.

Quantcast