Anglais428v2
New Member
- Joined
- Jun 19, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Criteria | Value |
A | 10 |
A | 10 |
B | 20 |
C | 40 |
I would like a formula that sums the Value column based only on unique strings in the Criteria column.
For example, in the above sample, the output should be 70 (10+20+40). I.e. it should count the first A value but ignore the second A value.
I can't remove duplicates from the sheet, therefore looking for a formula-based answer.
Thanks