Hi there,

The #VALUE error occurs when Excel is unable to interpret a formula or function. In this case, it seems like the issue is with the external link to the source file. When the source file is closed, Excel is unable to retrieve the data required for the SUMIF formula, resulting in the #VALUE error.

To resolve this issue, you can try the following steps:

1. Open the source file and the workbook that contains the SUMIF formula.
2. In the workbook that contains the SUMIF formula, click on the cell that contains the formula.
3. In the formula bar, click on the external link to the source file. This will highlight the link.
4. Right-click on the link and select "Edit Link".
5. In the "Edit Links" dialog box, select the link to the source file and click on "Change Source".
6. In the "Change Source" dialog box, navigate to the location of the source file and select it.
7. Click on "Open" and then "OK" to close the dialog boxes.

This should update the link to the source file and allow Excel to retrieve the data required for the SUMIF formula, even when the source file is closed.

Alternatively, you can try copying the data from the source file and pasting it into the workbook that contains the SUMIF formula. This will eliminate the need for an external link and ensure that the data is always available, even when the source file is closed.