Sumifs Using Vlookup

I need a formula that will sum an amount from a table based off a company name and if a cell is populated with the word Credit. The trick is the company name is not repeated on each row. Example below. Each category will have a dollar amount already in it and collection data is for current month only. I have attached an example spreadsheet.

Company Category Month1 Month2 month3 Pending Col
ABC Charge
Payment
Credit Needed Formula
Debit

ABCD Charge
Payment
Credit
Debit

AMCE Payment
Credit
Debit