Convert SUMIFS formula to SUMPRODUCT

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

It's simple

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

Bob, thanks for the quick reply. I gave it a try, the result was #N/A.

I am attaching the files. The formula I was asking about is in the "Monthly Cash Flow Plan" formula is in the highlighted cell. The formula in that cell is slightly different from what I originally posted since I stripped down these spreadsheets to simplify them (and remove all my personal information and ,monthly budget tabs).

Monthly Cash Flow Plan.xlsx
Account Register.xlsx

Originally Posted by boopathiraja

Hi, Del the error values, in Register from row13 to 21 the formula will work

Thanks! That works, and makes sense. I changed the formula in the register to it doesn't return error values. I'll explain below should it be of any benefit to someone finding this thread.

The error values were a result of the sheet referencing a lookup, but since the reference field was blank it returned error values. So I changed the formula in the register sheet to return blanks if the reference is blank and that removed the errors. (The reference field being column "D"). I changed the lookup to be =IF(D79<>"",VLOOKUP(D79,Category,4,FALSE),"")


Thank you both for your help!