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?


"Pete_UK" wrote:

Slight amendment to your final attempt:

=SUM(IF((E1275:E1299=A16)*(G1275:G1299=A14),AN1275 :AN1299))

then commit using Ctrl-Shift-Enter instead of the usual <Enter,
because this is an array formula.

Hope this helps.

Pete

On Jul 31, 11:19 pm, lleytte
wrote:
I'd like to sum if two conditions are met. Here's what I've tried, but didn't
work.
=SUM(IF(E1275:E1299,A16,AN1275:AN1299)*(G1275:G129 9,A14,AN1275:AN1299))

I also tried
=SUMIF(E1275:E1299,A16,AN1275:AN1299)*(G1275:G1299 ,A14,AN1275:AN1299)

My final attempt
=sum(if(E1275:E1299=A16)*(G1275:G1299=A14),AN1275: AN1299,false)

all I get is #VALUE? or #NAME? or it doesn't accept

Can someone tell me what I'm doing wrong? Thanks.