in d1 enter:

=SUMPRODUCT(--(LEFT(A1:A8,2)="50"),--(RIGHT(A1:A8,3)="200"),B1:B8)


"FGOMEZ" wrote:

I have 2 columns as follow:
Code Amount
1000.200 75.00
5000.100 50.00
5000.200 100.00
5010.200 100.00
5020.200 100.00
5100.100 150.00
5200.100 175.00
5300.200 170.00
and so on I am trying to build a formula that gives me the summary of all
the codes that start with 50 and end with 200, the total have to meet the 2
conditions.
Your help will be very much appreciated.

Fernando