getting the total of debits and credits

Hello. I have this super complicated lookup that I need to do. Accountants at arms!! I want pull the total expense from a sheet for a particular line item.

For example, 5031-100 is an account related to an expense. However, there are often multiple rows with that same value (they are not always unique).

There are also credits and debits. A debit increases the expense and a credit reduces it.

So, how would I lookup this up and sum any debits and subtract any credits related to that account? Example attached.

Debit increase, credit reduces...so 100-500= -400. I'll take a look at your formula. Thanks.

I tried this. =SUMIF(Sheet2!C:C,C3&"-"&B3,June!E:E), but it didn't work. It's returning 0.

Hmm, it works if I put the criteria in quotes. At least on a sample test sheet. Let me try on the original with & formula above.