Hi all,
I have stuck one more problem. I tried to search through earlier questions
but didn't find solution.

I have 2 files, first has product code (column A), name and another
information between and batch amount in packaging column J and kg column K.

In second file there is column A the same product code (6 numbers) and
column G is total amount per year, H is total amount kg per year. I have
formula

=COUNTIF('[File1.xls]Sheet1'!$A$3:$A$316;A2)

and it works fine if source is open. After source is closed or only file2 is
opened and updated, error #VALUE! appears. Is this avoidable and if so,
how...?