Hello, I have seen many threads on converting SUMIFS to SUMPRODUCT but I have been unable to successfully get mine right. I want to convert the formula below to SUMPRODUCT so it will work without having to open the source workbook. Any help would be greatly appreciated.

=SUMIFS('[Account Register.xlsx]REGISTER'!$H$7:$H$501,'[Account Register.xlsx]REGISTER'!$A$7:$A$501,$D$19,'[Account Register.xlsx]REGISTER'!$F$7:$F$501,C20)

Thanks,
Tim