Hi,

Try this

=SUMPRODUCT((INDIRECT($AW$3&"!$O$1:$O$6000")="XN01 ")*(INDIRECT($AW$3&"!$BL$1:$BL$6000")="A"+(INDIREC T($AW$3&"!$BL$1:$BL$6000")="B"))*(INDIRECT($AW$3&" !$CI$1:$CI$6000")))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JPDS" wrote in message
...
I'm having problems getting the following to work:

=SUMPRODUCT(--(INDIRECT($AW$3&"!$O$1:$O$6000")="XN01"),--(INDIRECT($AW$3&"!$BL$1:$BL$6000")={"A","B"}),(IND IRECT($AW$3&"!$CI$1:$CI$6000")))

The formula works when I only use one criteria in the range for $BL i.e.
{"A"}, but as soon as I add more than one criteria in, I get an error.

Thanks