=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.