SUMIF error

Hi, I have used the SUMIF function on a workbook to pick up the data from another workbook. But everytime I update the workbook the values are no longer pulled through and the cell shows #VALUE. If I have the other workbook open while I update the first one then I do not get this error. Please could someone assist.

Or work with just 1 workbooks if you want to carry on use sumif. If not then use SUMPRODUCT as Pepe Le Mokko Suggest.