Changing countifs into sumproduct

[Bandito1]

Hi all,

SOmeone able to help me with the following?

I would like to change this COUNTIFS formula into SUMPRODUCT cause now i need to have the other excel open in order to see results.
If it's closed i see #VALUE

=COUNTIFS('[Registratie review.xlsx]2016-2022'!$H:$H;">="&B3;'[Registratie review.xlsx]2016-2022'!$H:$H;"<="& EOMONTH(B3;0))

If im right, when it's SUMPRODUCT the other file doesn't need to be opened when you wanna see values. So no #VALUE error

 

[Fluff]

How about

=SUMPRODUCT(('[Registratie review.xlsx]2016-2022'!$H$2:$H$1000>=B3)*('[Registratie review.xlsx]2016-2022'!$H$2:$H$1000<=EOMONTH(B3;0)))

 

[Bandito1]

That works like it should, thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.