No VBA code running which is trying to set a FormulaArray property of a
range. The fix is out under Help and support, article ID 885245. States SP2
fixes this error. I have SP3 loaded since updated computer a couple weeks ago
and now receiving this error. I would think SP3 would contain all fixes
included in SP2 but doesn't appear to be the case. Never had the problem
prior to upgrade. I use the conditional sum array formula all the time-never
had a problem prior to this.

"Rick Rothstein (MVP - VB)" wrote:

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 worksheet 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" wrote in message
...
=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" spreadsheet. It will
work
if I enter on same spreadsheet but don't want it there. Have always been
able
to write this formula to show summaries on a separate spreadsheet within
the
same workbook.

"Rick Rothstein (MVP - VB)" wrote:

It might help if you show us your code

Rick


"sharon t" wrote in message
...
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.