Ok say I have multiple sales men and every time they post a sale I write it in a list.

So for example,

[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[TD="width: 67, align: right"]1[/TD]

[TD="width: 67, align: right"]21[/TD]

[TD="width: 67"]John[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]30[/TD]

John

[/td]

[TD="align: right"]3[/TD]

[TD="align: right"]50[/TD]

Jack

[/td]

[TD="align: right"]4[/TD]

[TD="align: right"]20[/TD]

Paul

[/td]

[TD="align: right"]5[/TD]

[TD="align: right"]10[/TD]

John

[/td]

[TD="align: right"]6[/TD]

[TD="align: right"]40[/TD]

John

[/td]

[/TABLE]

I want to know the average of Johns last three sales at t = 6, which is 26.66668

I also want to know the average of Johns last three at t = 5, which is 20.33333

I want to be able to drag the formula down.

Thank you in advance.

Sam