M
MDI Anne
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.
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.