SUMIF OR SUMPRODUCT??

[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.

 

[T. Valko]

I'm assuming MYWORKBOOK is just shorthand and you're using the correct
path/file name/sheet name.

Try it like this:

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

 

[MDI Anne]

Perfect!! After I corrected mine with yours...I got a DIV/0...and when I
got that corrected... voila!!

Thank you!!

 

[T. Valko]

You're welcome. Thanks for the feedback!