SUM Multiple Records in One Table to a Single Cell in Another Table|General Excel Questions & Answers|Excel Forum|My Online Training Hub

This is my first post; please be kind.
I have two tables.
First table (Master_Donor_Table) has individual records (no dups); first column is ID field, second column is TOTAL $$$ amount, which should be a sum from second table.
Second table (Master_Cost_Table) has same ID field in first column, second column is currency, HOWEVER this second table includes duplicate IDs.
I need to summarize all occurrences of an ID from the 2nd column of second table (Master_Cost_Table ($$$ Received)) into an individual ID/cell in the second column of first table (Master_Donor_Table).

In cell B2 of the Master_Donor_Table, I've tried the following:
=SUMPRODUCT(SUMIF([Donor ID],Master_Cost_Table[Donor ID],Master_Cost_Table[Total Received]))
=SUM(INDEX(Master_Cost_Table,2,MATCH([@[Donor ID]],Master_Cost_Table,0)))
=SUM(SUMIF(Master_Cost_Table[Donor ID],[Donor ID],Master_Cost_Table[Total Received]))
As well as several more attempts. At this point I'm lost. Would be grateful for any assistance.

I need to do this with formulas, NO VBA.
Using Microsoft 365 for Enterprise on a PC.

Thank you in advance for any assistance provided.

George