D
DMc2004
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
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