| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF Returns a #VALUE error when external source is closed
When I am using multiple workbooks, and have data in one book, and a sumif
function in the other I am receiving an error. When the data source is open everything works fine, but should I close the external data source then re open and update the workbook which has the SUMIF function then I receive a #VALUE error. =sumif([Workbook.xls]Sheet1'!$A$1:$A$3,=1,[Workbook.xls]Sheet1'!$B$1:B$3) I would appreciate any suggestions on this matter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
| incorporating live data from external source to work book | Excel Discussion (Misc queries) | |||
| Pivot and changing External data source | Excel Discussion (Misc queries) | |||
| Sumif range returns #NUM! | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
