Countif referencing another WB

J

John

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
 
D

Dave Peterson

You could use:

=sumproduct
(--('H:\Work\[Cases_Older_Than_One_Year.xls]131106'!S1:S999="Closed"))

(all one line)

But you can't use the whole column (xl2003 and below, anyway).
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
Click to expand...
 
Top