I have 2 sumifs fomulas. I would like to use one vs the other based on if 3 criteria are met or not. If statement not working

First post here. Looking for some guidance as an excel novice.

I have a daily CSV report which I copy and paste to a "Data Dump" tab (dynamic). A "Data Pull" tab pulls and populates from this daily data dump.

I want cells in the "Data Pull" tab to determine whether the relevant sumifs should be a positive(debit) or negative(credit) figure based on 4 different criteria. (Date, master acct #, and sister acct #, Credit vs. Debit). The unique identifier in this instance is whether the item is a "Credits" or "Debits". If the item being pulled is a "Credit" then it should be a negative figure.

I've tried If(AND statements with multiple criteria.

Tried IF array statements with multiple criteria

Tried to incorporate isnumber(search) as well.

=IF(AND('Data Dump'!$B:$B='Data Pull'!$A$1,'Data Dump'!$A:$A='Data Pull'!$B6,'Data Dump'!$H:$H='Data Pull'!C6,'Data Dump'!$C:$C="Credits"),SUMIFS('Data Dump'!$F:$F,'Data Dump'!$B:$B,'Data Pull'!$A$1,'Data Dump'!$H:$H,'Data Pull'!C$5,'Data Dump'!$A:$A,'Data Pull'!$B25)*-1,SUMIFS('Data Dump'!$F:$F,'Data Dump'!$B:$B,'Data Pull'!$A$1,'Data Dump'!$H:$H,'Data Pull'!C$5,'Data Dump'!$A:$A,'Data Pull'!$B25))

Here is my current statement that is not working. It is probably a bit redundant; but am not sure how to properly lay this data pull out. Probably overthinking this ... but there is a lot of logic throughout.

Please reference excel file attached.

Excel Dummy File