Sumifs does not work when a workbook is closed

[zeidhaddad]

=SUMMEWENNS('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$C$2:$C$1703;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J$2:$J$1703;B19;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A$2:$A$1703;F6)

as well all know whenever i close the other workbook it gives #Value, can anyone help me to translate it into a working function when the workbook is closed ?
i read something about SumProduct but i did not understand it very well so HELP!!!!!!

 

[zeidhaddad]

Re: Sumfs does not work when a workbook is closed

Very helpful like always! thank you again sir.