Total cells if the name/account# in a different cells match.

[autoofficemanagement]

I have a spreadsheet with different names/account numbers and each line has a payment amount. How do I total only the amounts with the same names/account ID without having to manually Sum the payment amount. What is the formula to total payment amounts IF the name/acct# is identical?  I would like a new column to have the total. I need a total for each customer even if there are not multiple payments The only data that I do not have is the TOTAL PAID column which is what I am looking to create. 

Example below:

Tran ID	Tran Post Date	Acct ID	Name	Amount	TOTAL PAID
123489	07/16/2024	850804	Paul Armstrong	70.00
123759	07/12/2024	850804	Paul Armstrong	70.00	140.00
135554	07/15/2024	850805	Niki Ashton	140.00	140.00
135578	07/25/2024	850111	Karen Webster	235.00
134469	07/26/2024	850111	Karen Webster	235.00	470.00

[#2]

@autoofficemanagement 

=IF(COUNTIFS($D$2:$D$6,D2,$C$2:$C$6,C2)=COUNTIFS($D$2:D2,D2,$C$2:C2,C2),SUMIFS($E$2:$E$6,$D$2:$D$6,D2,$C$2:$C$6,C2),"")

This formula returns the intended result in my sample file. The formula is in cell G2 and filled down.

[#3]

@autoofficemanagement 

Alternatively you may use PivotTable to calculate totals for each account