Vlookup with condition in Data

[abalboul]

Hi,
I'd like to use Vlookup but with Condition in data;
I have the following data:

A B
10 01 1000$
10 02 500$
10 03 150$
11 04 80$
11 05 150$

I want a function to go over the column A, if the Code starts with 10, then i want to have a total of: 1000+500+150;
Many thanks for your help

 

[VoG]

Try

=SUMIF(A:A,"10*",B:B)

 

[abalboul]

Many thanks Peter!