Think you had some typos/extra bits in your expression

I managed to get Excel to accept this cleaned up expression,
array-entered (press CTRL+SHIFT+ENTER):
=SUM(IF(('Jul ''08'!E1275:E1299='SPC Report'!A16)*('Jul
''08'!G1275:G1299='SPC Report'!A14),'Jul ''08'!AX1275:AX1299))

It assumes of course, that you have 2 other sheets named:
SPC Report
Jul '08
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"lleytte" wrote:
I'm actually using it between sheets in a workbook so I input
=sum(if(('Jul ''08'!E1275:E1299='SPC Report'!A16)*('Jul
''08'!G1275:G1299='SPC Report'!'SPC Report'!A14),'Jul ''08'!AX1275:AX1299))

then commit, but it doesn't accept the formula.

Does it not work this way?