Hi,
I have entered a formula as shown below; however, using an external source, it will not work when closed.
Tried to solve with SUM(IF) - but search criteria won't go throug4h.
Any suggestions on how to solve?
=SUMIFS('[ExternalSheet.xlsx]Input'!$P:$P;'[ExternalSheet.xlsx]Input'!$I:$I;"*es";'[ExternalSheet.xlsx]Input'!$M:$M;$B61;'[ExternalSheet.xlsx]Input'!$C:$C;SameWorkbook!$G$1)
Thanks
Bookmarks