Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif referencing another WB
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). John wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF using # ranges, and referencing 2 other columns | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
Referencing previous column in COUNTIF | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |