SUMIF OR SUMPRODUCT??

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

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)
 
M

MDI Anne

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

Thank you!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top