Hi

I have just moved your post in the right forum.

As far as VALUE error, I think the SUMIF won't work if the source workbook is not opened. So you can do one thing to overcome this, not to update the links while opening the workbook. That way you can preserve the formula values.