Forum Discussion
Using average
I keep a golf spread sheet that has all the points of each round. For handicapping purposes, we use the average of the last six scores. Since not every player plays each week, the six scores needed...
For such sample
formula could be
=AVERAGE(INDEX($E4:AP4,AGGREGATE(14,6,1/($E4:AP4>0)*(COLUMN($E4:AP4)-COLUMN($E4)+1),{1,2,3,4,5,6})))The only don't place any other data to the right of date columns and take big enough range which covers all potential dates.