hi, all !

Pete_UK wrote in message ...
Wouldn't you need the full path if the file is closed?

since OP posted a formula without the full-path, I assumed he's working (only ?) with source file opened
as soon as the source file is closed, each reference in formulae change to it's full-path (but)...
as Tony says, sumif(... countif(... doesn't work on closed files, so forth his proposal was...

regards,
hector.

T. Valko wrote in message ...
Note that COUNTIF requires the source file be open.
An alternative that works whether the source file is open or closed:
=IF(COUNT(MATCH(A6,'[Catalogue Robs Test Stock Range.xls]Catalogue'!$A$1:$A$5000,0)),"YES,"NO")