On 2002-05-08 19:37, NOCHOKE wrote:
Aladin, I couldn't get yours to work.

Mark, With yours I get the right result in A2, but it does not change when I add test figures in B1, C1, D1, etc. What am I missing?
You need to copy (or fill) my formula [ =ROUNDUP((SUM(OFFSET(A1,,-MIN(3,COLUMN()-1),,MIN(4,COLUMN())))-MIN(4,COLUMN())*36)*80%,0) ] entered into cell A2 to B2, C2, D2, E2, etc. As you requested ("After week 4, we go to a handicap based on the same 80% as noted above, except that we use the last four rounds only.") my formula provides results in A2 based on A1, in B2 based on A1:B1, in C2 based on A1:C1, in D2 based on A1:D1, in E2 based on B1:E1, in F2 based on C1:F1, etc.

[ This Message was edited by: Mark W. on 2002-05-09 08:09 ]