Help needed with changing SUMIFS to SUMPRODUCT

Hi,

Maybe you will be able to help me. I have small issue, the same one as I found here: http://www.excelforum.com/excel-prog...osed-file.html

I used formula SUMIFS and it works perfectly but I used two separate files so when I close one I have error.

Solution was to change formula for SUMPRODUCT but unfortunately I don't know how.

Can you please help to change my formula from SUMIFS to SUMPRODUCT:

=SUMIFS('[File Name.xlsx]Sheet Name'!H:H;'[File Name.xlsx]Sheet Name'!$A:$A;$A4;'[File Name.xlsx]Sheet Name'!$B:$B;$B4;'[File Name.xlsx]Sheet Name'!$D:$D;$D4)

I will be very Grateful for you answer!
Thanks.

Thank you so much!
It works.