Osama Fawzy
New Member
- Joined
- Aug 24, 2022
- Messages
- 39
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
- Mobile
Hi, I have the some formulas (such as the below), them linked in between 3 files and doesn't work and return #VALUE! when the source file closed and return the right value when the source file is opening
=IF(NOT(B2="SU-NMG"),SUMIFS('Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$C$7:$C$1199,'Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$B$7:$B$1199,">="&J2,'Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$B$7:$B$1199,"<="&L2),SUMIFS('[SU-NMG_2022.xlsb]AC TLB'!$C$7:$C$1199,'[SU-NMG_2022.xlsb]AC TLB'!$B$7:$B$1199,">="&J2,'[SU-NMG_2022.xlsb]AC TLB'!$B$7:$B$1199,"<="&L2))
=IF(NOT(B2="SU-NMG"),SUMIFS('Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$C$7:$C$1199,'Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$B$7:$B$1199,">="&J2,'Z:\Planning & Records Depratments\Aircrafts Technical Data\1-Aircraft''s Status\4-SU-NML\[SU-NML_2022.xlsb]AC TLB'!$B$7:$B$1199,"<="&L2),SUMIFS('[SU-NMG_2022.xlsb]AC TLB'!$C$7:$C$1199,'[SU-NMG_2022.xlsb]AC TLB'!$B$7:$B$1199,">="&J2,'[SU-NMG_2022.xlsb]AC TLB'!$B$7:$B$1199,"<="&L2))