Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You could use the OFFSET function instead of INDIRECT.

=AVERAGE(OFFSET(B$1,$O$2-1,0,$O$3-$O$2+1))

You could use the OFFSET function instead of INDIRECT.

=AVERAGE(OFFSET(B$1,$O$2-1,0,$O$3-$O$2+1))
=AVERAGE(OFFSET(B$1;$O$2-1;0;$O$3-$O$2+1))

Edit to use ";" instead of "," as "," would depend on locale settings.