Countifs into SUMPRODUCT

[zeidhaddad]

=CountIFS('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A:$A;">="&'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A$1684;'[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J:$J;B19)

Could anyone please help me translate this into a SUMPRODUCT ?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ot-work-when-workbook-closed.html#post5352472

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).