COUNTIF across multiple workbooks
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!
|