EXCEL FORMULA HELP NEEDED. NO BIDS FROM INDIAPAK REGION BUDGET $20

I need help with an excel spreadsheet creation with formulas column 1 Transaction Date column 2 Vendor name column 2 Project name column 3 Descrription column 4 Expense column 5 Capital column 6 Balance now to the difficult part: column 7 has list of all vendors, example Joe, Bob, Peter column 8 holds their totals any time there is a transaction in column 4 , for whom the vendor is 'Joe', that amount must be added to the total on column 8 against Joe's total. So I made transaction for $500 on 3-9-19 and $200 on 3/11/19, then Joe's total on column 8 must show $700 column 9 lists all projects by name, example Dodge, Chevy, Benz column 10 lists total amounts in each of these specific projects any time there is a transaction in column 4, for which the project name is 'Dodge' that amount is added to the total on colum 10 against Dodge's total. So if the transaction I made for $500 with Joe on 3-9-19 was for the Dodge project and the transaction i made on 3-21 with bob for the Dodge project was for $100, then the dodge total will add up to $600