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?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Art: 101K102345[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SO160584[/TD]
[TD]7.064[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Art: 101L940345[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SO16708[/TD]
[TD]6.593[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SO17405[/TD]
[TD]4.356[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Art: 403O034596[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?