Sum in column B depending on values in column A?

[N4nninga]

Hi,

I am looking for a solution for the following. In the column on the left I have different article numbers, each article number has one or more (up to 20) Sales Orders attached to it. For each article number, I would like to see the sum of all Sales Orders attached to that specific article number in the cell adjecent to the article number itself.

Does anyone have a suggestion as to how to approach this?

Art: 101K102345	?
SO160584	7.064
Art: 101L940345
SO16708	6.593
SO17405	4.356
Art: 403O034596

<tbody>
</tbody>

 

[vmjan02]

do sumif it will work

 

[Aladin Akyurek]

Presumably an article can be associated with more than one order. If so, care to post some data in order to see the layout?