Forum Discussion
Solved
SUMIF witch linekd documents
We have two files named: Excel-A and Excel-B They are linked with formula is in the Excel-B.xls file in the Utilization tab in row: H9 Formula: =-SUMIF('[Excel-A.xls]Income_new'!$M$49:$M$150...
- SUMIF does not work when the file containing the data is not open in Excel. There are several ways to work around this issue, the first being opening the linked file. Alternatively, you could have the file with the SUMIF function pull in the data from File A to a separate worksheet. Data tab, Get Data, From File (this creates a Query). Then you can point your SUMIF to the newly inserted tab. You can set the query to refresh when the file opens so the data on the new tab is up to date.
SUMIF does not work when the file containing the data is not open in Excel. There are several ways to work around this issue, the first being opening the linked file. Alternatively, you could have the file with the SUMIF function pull in the data from File A to a separate worksheet. Data tab, Get Data, From File (this creates a Query). Then you can point your SUMIF to the newly inserted tab. You can set the query to refresh when the file opens so the data on the new tab is up to date.
