AVERAGE with OFFSET

\1

The pic pretty much explains everything -- I need to create a draggable six-column average

A lot of people had a similar problem where they were averaging cells within one column; I, however, have to average cells within a row

I spent a lot of time tinkering with AVERAGE and OFFSET, but can't get it to work:

Please Login or Register  to view this content.

I was thinking about creating something along the lines of

Please Login or Register  to view this content.

Any input will be greatly appreciated

Thanks!

Try in AC3, then copy across & down.

Please Login or Register  to view this content.