Formula for how much a customer bought something

[nijsten8]

Dear all

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

 

[Marcílio_Lobão]

nijsten8, Good morning.

Suppose:

A1:B100 --> Sales Table

D4 --> CUSTOMER ID

Try to use:

=SUMIF(A1:A100, D4, B1:B100)

Is that what you want?
I hope it helps.