Dear all
I'm looking for a way to calculate the sum of what customers bought
<tbody>
</tbody>
For example, B007 bought 2 times (1 time 5 pieces, 1 time 2 pieces), in total 7 pieces. is there a formula to do this (quick)?
Thanks in advance
I'm looking for a way to calculate the sum of what customers bought
Customer | # |
D229 | 50 |
D190 | 60 |
D120 | 50 |
N003 | 1 |
N007 | 1 |
B053 | 5 |
B024 | 3 |
D190 | 2 |
N003 | 2 |
N007 | 3 |
B007 | 5 |
B003 | 2 |
B007 | 2 |
B053 | 5 |
<tbody>
</tbody>
For example, B007 bought 2 times (1 time 5 pieces, 1 time 2 pieces), in total 7 pieces. is there a formula to do this (quick)?
Thanks in advance