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
Hello George,
You were almost there, you can use different functions to get the result, for example SUMIF. Example below.
=SUMIF(Master_Cost_Table[Donor ID],[@[Donor ID]],Master_Cost_Table[Total Received])
Br,
Anders
=SUMIFS(Master_Cost_Table[Total Received],Master_Cost_Table[Donor ID],[@[Donor ID]])
