| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif-sumproduct | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| sumif or sumproduct? | Excel Worksheet Functions | |||
| SUMPRODUCT or SUMIF | Excel Discussion (Misc queries) | |||
| Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
Hybrid Mode
