referencing another workbook using formula with CountIf?

[jantzen16]

Greetings to all,

I am having a problem with CountIF function why it returns #VALUE. I have this current code

=COUNTIF([BOOK2.xls]Sheet1!$A:$A,A2)

Sample:
Filename - Book1.xlsx Sheet1 = A2 = Blue, B2 = ???
Filename - Book2.xlsx Sheet1 = A7 = Blue

it should be then Book1 Sheet1 B2 = "Exists"

Any idea ? Thank you so much..

 

[Andrew Poulsom]

Please stick with your original thread:

http://www.mrexcel.com/forum/showthread.php?t=532652

I have already told you that COUNTIF expects the workbook to be open. Nothing is going to change that fact.