=countif([Sales.xls]Sheet1'!$B$2,"test")

but since you just test one cell

=--( [Sales.xls]Sheet1'!$B$2="test")


--
Regards,

Peo Sjoblom





"George" wrote in message
...
Hi,

I am tring to use Countif between workbooks, but can't get it to work.
Here
is the formula I entered

=countif[Sales.xls]Sheet1'!$B$2."test"

It does not return a value, What should I do?

Thanks,

George