averaging every nth column working for all but 1 case

Originally Posted by shukla.ankur281190

Try

=AVERAGE(OFFSET(D1,1,,21))

I do not believe this works. The values are not correct.