hi,
i am getting data from linking cell
there is a problem in above formula![]()
=COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[30.6.17.XLSB]TOTAL BC VC'!$C$4:$C$100)
if workbook not found its giving answer = 97
while i need 0
thank you
hi,
i am getting data from linking cell
there is a problem in above formula![]()
=COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[30.6.17.XLSB]TOTAL BC VC'!$C$4:$C$100)
if workbook not found its giving answer = 97
while i need 0
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks