Hi,
I have a =SUMIF & =IF formula written within a sheet. They both point towards another spreadsheet to harvest data and I have noticed that the data is fetched automatically within the =IF formula (without the other sheet open) but the =SUMIF formula only displays the data when I open the other sheet.
Is there a way I can get the =SUMIF cell to update with the need to open up the file each time?
=IF($A11="","",IF(ISNA(MATCH($A11&"_"&COLUMN(A$5),'\\ORBITALHUB\Employees\Greg Tudor\Greg Folder\[Test.xlsx]Sheet1'!$M:$M,0)),"",INDEX('\\ORBITALHUB\Employees\Greg Tudor\Greg Folder\[Test.xlsx]Sheet1'!$J:$J,MATCH($A11&"_"&COLUMN(A$5),'\\ORBITALHUB\Employees\Greg Tudor\Greg Folder\[Test.xlsx]Sheet1'!$M:$M,0))))
=SUMIF('\\ORBITALHUB\Employees\Greg Tudor\Greg Folder\[Test.xlsx]Sheet1'!$C$2:$C$101786,A11,'\\ORBITALHUB\Employees\Greg Tudor\Greg Folder\[Test.xlsx]Sheet1'!$F$2:$F$101786)
Bookmarks