Thanks for that. The SUMPRODUCT worked much better than stringing COUNTIF.

Now I would like to be able to take the team name from column E and look in
Column H for a Y or N and then report back to the results sheet the count of
Y's & N's (in seperate columns). So if CCR A had three Y's and two N's the
results sheet shows the total team count (where I used the SUMPRODUCT) in
column B, Correct Results (represented by a Y on the individual sheets) in
column C and Errors (represented by a N on the individual sheets) in column D.

Is this possible?

"Bob Phillips" wrote:

COUNTIF doesn't work with a closed workbook, so I suggest that you change it
to SUMPRODUCT. Then just string the formulae

=SUMPRODUCT(--('I:\CCR\SAM\7057\[NSIR2007_7057.xls]NSIR Data'!$E:$E=A2))+
SUMPRODUCT(--('I:\CCR\SAM\7057\[NSIR2007_8081.xls]NSIR Data'!$E:$E=A2))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)