Would greatly appreciate any help on the following:
I use the following fuction in a cell:
=IF(COUNTBLANK('C:\Documents and Settings\efthimis\My Documents\EFTHIMIS\BCM\CUSTOMERS\IND-112 ΕΛΒΕ\IND112-1\[IND112-1 ΠΟΡΕΙΑ ΕΡΓΟΥ & ΑΝΑΛΥΣΗ ΑΜΟΙΒΗΣ.xls]ΠΟΡΕΙΑ ΕΡΓΟΥ'!L2:L4)=0;"ü";"")
If the file in reference is not open, I get a an 'Error in Value' message. Can anyone please explain to me why the function works only when the file in reference is open?
Thanks in advance
I use the following fuction in a cell:
=IF(COUNTBLANK('C:\Documents and Settings\efthimis\My Documents\EFTHIMIS\BCM\CUSTOMERS\IND-112 ΕΛΒΕ\IND112-1\[IND112-1 ΠΟΡΕΙΑ ΕΡΓΟΥ & ΑΝΑΛΥΣΗ ΑΜΟΙΒΗΣ.xls]ΠΟΡΕΙΑ ΕΡΓΟΥ'!L2:L4)=0;"ü";"")
If the file in reference is not open, I get a an 'Error in Value' message. Can anyone please explain to me why the function works only when the file in reference is open?
Thanks in advance