You could combine the SUMPRODUCT and RIGHT functions.

In C2

=SUMPRODUCT((RIGHT(A1:A500,2)*1=Your customer ID)*(B1:B500))

If you also need to incorporate the product number then:

=SUMPRODUCT((RIGHT(A1:A500,2)*1=Your customer ID)*(LEFT(A1:A500,3)*1=Your Product number)*(B1:B500))

Does that help?


Steve