| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif to external file
I'm trying to create a sumif statement that pulls data from an external file.
I am also trying to enter the path of the file using the full UNC path. If I create the formula without entering the UNC and just leave it as the default file name etc. it works fine. With the UNC path, I get the error. It also appears that the linked file needs to be open or it returns a value error. Is this true that both files do need to be open? -- harriettbird |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif to external file
Use SUMPRODUCT instead of SUMIF...
=SUMPRODUCT(--(CondRange="Criteria"),RangeToSum) If the criteria is a numerical value, remove the quotes. Hope this helps! In article , harriettbird wrote: I'm trying to create a sumif statement that pulls data from an external file. I am also trying to enter the path of the file using the full UNC path. If I create the formula without entering the UNC and just leave it as the default file name etc. it works fine. With the UNC path, I get the error. It also appears that the linked file needs to be open or it returns a value error. Is this true that both files do need to be open? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I email amacro? | Excel Worksheet Functions | |||
| External file references must be open? | Excel Discussion (Misc queries) | |||
| Getting an external file creation date as data | Excel Discussion (Misc queries) | |||
| Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
| Import External Data Source File Location Changed | Excel Discussion (Misc queries) | |||
Linear Mode
