hi,
i am getting data from linking cell

=COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[30.6.17.XLSB]TOTAL BC VC'!$C$4:$C$100)
there is a problem in above formula
if workbook not found its giving answer = 97

while i need 0

thank you