I was still saying you had to string SPs, just that Sp would work whereas
COUNTIF won't on a closed workbook.

Already answered other part in earlier response.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JDB" wrote in message
...
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)