Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

calc - vary column in indirect

Assume two sheets Sheet1_2, Sheet1_3 that have some values on columns B-K.

Each sheet has

R2=AVERAGE(INDIRECT("b"&$O$2):INDIRECT("b"&$O$3))
R3=STDEV(INDIRECT("b"&$O$2):INDIRECT("b"&$O$3))

for, say,

O2=1436
O3=10260

How can I write the indirect s.t. I can drag it right to sumarise the other columns?

i.e.

S2=AVERAGE(INDIRECT("c"&$O$2):INDIRECT("c"&$O$3))
S3=STDEV(INDIRECT("c"&$O$2):INDIRECT("c"&$O$3))
T2=AVERAGE(INDIRECT("d"&$O$2):INDIRECT("d"&$O$3))
T3=STDEV(INDIRECT("d"&$O$2):INDIRECT("d"&$O$3))

calc - vary column in indirect

Assume two sheets Sheet1_2, Sheet1_3 that have some values on columns B-K.

Each sheet has

R2=AVERAGE(INDIRECT("b"&$O$2):INDIRECT("b"&$O$3))
R3=STDEV(INDIRECT("b"&$O$2):INDIRECT("b"&$O$3))

for, say,

O2=1436
O3=10260

How can I write the indirect s.t. I can drag it right to sumarise the other columns?

i.e.

S2=AVERAGE(INDIRECT("c"&$O$2):INDIRECT("c"&$O$3))
S3=STDEV(INDIRECT("c"&$O$2):INDIRECT("c"&$O$3))
T2=AVERAGE(INDIRECT("d"&$O$2):INDIRECT("d"&$O$3))
T3=STDEV(INDIRECT("d"&$O$2):INDIRECT("d"&$O$3))