| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Multiple Workbooks
Hi All
Currently go a problem with the SumIf Worksheet Function. I have a list of data stored in a workbook. Lets say C:\Temp\Source.xls. I have a Input Sheet stored in C:\Temp\Input.xls. In cell A2 on the Input Sheet I have a value entered called March. In cell A3 on the Input Sheet I have a formula: #Value! It does not come up if both workbooks are open. Kind Regards D =SUMIF('C:\Temp\[Source.xls]Sheet1'!$A$2:$A$30,B3,'C:\Temp\[Source.xls]Sheet1'!$B$2:$B$30) Why does the cell come up with error |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| My sumif formulas containin links to other workbooks do not calcul | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
