Hi Excel peoples.
I have the following formulae that does not work as expected.
I have one row of data that I wish to average every 7th Column. The 1st cell to average starts at X10
=AVERAGE(OFFSET($X$10,,(COLUMNS($X$10:X10)-1)*7,,7))
Any thoughts.
Bookmarks