Please Correct the Formula,

[srizki]

One of colleague is using the following formula,

{=(SUM(('Revenue,ConMgmt,COS'!$A$2:$A$1000='2012 TOTALS'!$A46)*('Revenue,ConMgmt,COS'!$D$2:$D$1000='2012 TOTALS'!$J$23)*'Revenue,ConMgmt,COS'!$G$2:$G$1000))}

I tried to change it to not using array formula and used this,

=SUMPRODUCT('Revenue,ConMgmt,COS'!$A$2:$A$559='2012 TOTALS'!A46)*('Revenue,ConMgmt,COS'!$C$2:$C$559='2012 TOTALS'!$J$23)--('Revenue,ConMgmt,COS'!$G$2:$G$559)

But my formula is not working.
Please advise.

Regards,

 

[Jonmo1]

Try

=SUMPRODUCT(--('Revenue,ConMgmt,COS'!$A$2:$A$559='2012 TOTALS'!A46),--('Revenue,ConMgmt,COS'!$C$2:$C$559='2012 TOTALS'!$J$23),'Revenue,ConMgmt,COS'!$G$2:$G$559)

 

[srizki]

Thank you very much Jonmo1