Ok, I have the following as my SUMPRODUCTS function:

=SUMPRODUCT(--('S:\Major Projects\6917-11 Gomez\revenue and cost
tracking\Vessel Reports\[PS-MR-RP-DMR 01 Jul
05.xls]DMR'!$N$182:$Q$254="Fugro"))

And I'm runing 3 of these on different parts of a workbook. 3 Different
parts of the same workbook. But the problem is the 3rd time its doing
it, it refused to look at the unopened workbook.

Any suggestions?

J.