I have a pretty complicated sheet that is calculating the average for the last 3 days, 6, 12 and 24 days. I have noticed that the answers fro 3 & 6 days are correct, but the 12 & 24 days are not correct.
=AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer...