I might confused you. If i apply above rule, the result would show as 0 or "".put an
=Iferror(existing formula, 0) or
=Iferror(existing formula, "")
around your existing formula
Thanks for your response and tip.SUMIF function require the linked workbook to be open, otherwise it will return #VALUE! error.
You can fix by using SUMPRODUCT function instead of SUMIF and could keep the result when the linked workbook is closed, as in :