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?

Can anyone help with the below? I'm really stuck with this!

"JDB" wrote:

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?