Countif referencing another WB
Hi,
I use =COUNTIF('H:\Work\[Cases_Older_Than_One_Year.xls]131106'!S:S,"Closed")
When the WB is open it returns a value. When closed i get #VALUE!
Is this just the feature of this function in XL, if so, would anyone suggest
an alternative please?
Thanks
John
|