|
SUMIF OR SUMPRODUCT??
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. |
SUMIF OR SUMPRODUCT??
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$2660%),G2:G23) -- Biff Microsoft Excel MVP "MDI Anne" wrote in message ... 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. |
SUMIF OR SUMPRODUCT??
Perfect!! After I corrected mine with yours...I got a DIV/0...and when I
got that corrected... voila!! Thank you!! "T. Valko" wrote: 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$2660%),G2:G23) -- Biff Microsoft Excel MVP "MDI Anne" wrote in message ... 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. |
SUMIF OR SUMPRODUCT??
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "MDI Anne" wrote in message ... Perfect!! After I corrected mine with yours...I got a DIV/0...and when I got that corrected... voila!! Thank you!! "T. Valko" wrote: 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$2660%),G2:G23) -- Biff Microsoft Excel MVP "MDI Anne" wrote in message ... 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. |
| All times are GMT +1. The time now is 12:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com