Weighted average for last X number of sales

[marcushjalmarsson]

Hello

I cannot figure this out, hoping you will

I have a table consisting of Art.no./Month/Volume/Price

[TABLE="width: 258"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]Art.no.[/TD]
[TD]Month[/TD]
[TD]Volume[/TD]
[TD="align: center"]Price[/TD]
[/TR]
[TR]
[TD]210015[/TD]
[TD]1612[/TD]
[TD]200[/TD]
[TD] 190,00 [/TD]
[/TR]
[TR]
[TD]210015[/TD]
[TD]1702[/TD]
[TD]200[/TD]
[TD] 200,00 [/TD]
[/TR]
[TR]
[TD]210015[/TD]
[TD]1705[/TD]
[TD]200[/TD]
[TD] 200,00 [/TD]
[/TR]
</tbody>[/TABLE]

In Another sheet I would like to enter Art.No. ant volume and get the Weighted average for the last sold coinciding with the volume I have entered.


Example of entry:

ArtNo Volume
210015 500

Then I want the formula to return the number 198. Instead of 196,6667

Does anybody have any idea how to do this?


Much Appriciated
Marcus
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

How did you obtain 196,6667 given the input you posted?