countif in links
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 |
=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 |
First, the period before "test" should be a comma. Second, the target files (sales) needs to be open for the formula to work. -- nbrcrunch |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com