sum one column based on another

[scalvitto0815]

i have 100 lines of data A10 to B 10 col A has code numbers and column B has amounts. Is there a foruma i can enter in b2 that will give me the sum of allamounts in Col B based on the fiorst position of the codes in Col A. I would like to enter the code in A1

 

[Fluff]

How about

=SUM(FILTER(B12:B17,LEFT(A12:A17,LEN(A1))=A1&""))

 

[scalvitto0815]

How about

=SUM(FILTER(B12:B17,LEFT(A12:A17,LEN(A1))=A1&""))

That worked. Thanks so much.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[scalvitto0815]

Your codes are actually like this. Or this is just a sample data?

THANKS for your help !!