In Excel 2010, I have 2 tabs:
Summary Tab
Bank Tab
In Bank Tab:
Col A Col B Col C Col D
SC New acct123 5000
SC New acct123 5000
SC New acct123 1000
SC Renew acct123 2000
GA New acct125 1000
GA New acct125 1000
SC Renew acct126 6000
In the Summary Tab:
Col A Col B Col C
SC New ?? formula I have so far: =SUMIFS(Bank!$D:$D,Bank!$A:$A,Summary!$A$2,Bank!B:B,Summary!B2)
I want to add col D (from Bank tab) using mutiple distinct criterias based on Column A, B, C, and D (from the Bank tab), but not summing any of the duplicates.
The result in Col C (in the Summary tab) should be: 6000
The formula I have above is incomplete, it does not filter out the duplicates.
Can anyone help?
Bookmarks