I am using the sumif function to return values from a linked workbook. When
the linked workbook is not open, however, the cells using this formula
returns a #VALUE! error. I have tried using SUMPRODUCT, but I get another
error message. Maybe it's how I have the formula setup??

=SUMIF(MYWORKBOOK$DC$5:$DC$26,"60%",H2:H23)

=SUMPRODUCT(--(MYWOOKBOOK$DC$5:$DC$26,"60%",G2:G23))

Anyone have any suggestions to fix this?

What I can't understand is WHY I get the #VALUE! when the linked workbook is
closed, but when I open it, the values are "popped" into the cells...

Thanks.