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)


"JDB" wrote in message
...
Hi,

I currently have 5 different workbooks for use by 5 seperate team members.
I
need to collate the data from those 5 workbooks into a seperate book.

An example workbook is NSIR2007_7057.

Each workbook is laid out identically - all the columns have the same
headings. For example, I need to count the number of times a team name
appears, can I extend the formula below to include the other 4 workbooks
and
if so, how do I do it?

=COUNTIF('I:\CCR\SAM\7057\[NSIR2007_7057.xls]NSIR Data'!$E:$E,A2)

(E is the column containing the team name and A2 is the cell on the
results
workbook specifying the team name to look for)

Any help is greatly appreciated as always!