Multiple criteria over Multiple sheets

[JDB]

I currently have a spreadsheet for pulling together the data from other
worksheets. I use the following formula;
=SUMPRODUCT(--([NSIR2007_7057.xls]JAN07!$E3:$E9999="CCR A"),
--([NSIR2007_7057.xls]JAN07!$S3:$S9999="Y")). I need to keep the first
sumproduct as I still need to identify by team, but I need to change the
second part to first check column S for a Y or N, and based upon the outcome,
check column AC for the phrase NO ERROR (so if there is a Y in column S, AC
is checked for NO ERROR, if an N is in column S, do nothing).

Can anyone help at all?

 

[Max]

Try:
=SUMPRODUCT(--([NSIR2007_7057.xls]JAN07!$E3:$E9999="CCR
A"),--([NSIR2007_7057.xls]JAN07!$S3:$S9999="Y"),--([NSIR2007_7057.xls]JAN07!$AC3:$AC9999="NO ERROR"))