Mr Retirement
New Member
- Joined
- Nov 12, 2016
- Messages
- 46
Hello!
I'm looking for a formula (maybe sumifs?) that will lookup the 'Name' column and 'ID' column and return the sum of the 'Amount' column BUT for only those ID's that are unique. For example, if I lookup Name "ABC" it should return 550 because it'll sum 200 + 350... not both 200's because they have the same ID. I have the ability to create helper columns if needed. Any suggestion is great!
<tbody>
</tbody>
Thanks,
Mr R.
I'm looking for a formula (maybe sumifs?) that will lookup the 'Name' column and 'ID' column and return the sum of the 'Amount' column BUT for only those ID's that are unique. For example, if I lookup Name "ABC" it should return 550 because it'll sum 200 + 350... not both 200's because they have the same ID. I have the ability to create helper columns if needed. Any suggestion is great!
Formula Column | Name | ID | Amount |
? (should equal 550) | ABC | 123 | 200 |
? (should equal 550) | ABC | 123 | 200 |
? (should equal 550) | ABC | 234 | 350 |
? (should equal 450) | BCD | 345 | 300 |
? (should equal 450) | BCD | 456 | 150 |
<tbody>
</tbody>
Thanks,
Mr R.