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