Variable Member Averages

[rwmill9716]

I have a set of 1,000 numbers in columns A-J, rows 1-1000.

I want to specifiy a number (1-10) in cell L1 (say 7 for example) then have the
macro calculate the average of the first 7 columns in col K for all
1,000 groups of numbers.

A 10 in cell L1 would lead to the average of all 10 columns (A-J) being
calculated in col K.

Thanks,

ric

 

[Straha]

You could try this in cell K1

=AVERAGE(INDIRECT("A1:"&(CHAR(64+INT($L$1)))&"1000"))

to give the average of groups.

Or this in K1 and copy down for the average of each row.

=AVERAGE(INDIRECT("A"&ROW()&":"&(CHAR(64+INT($L$1)))&ROW()))

I am a little unclear about what you are trying to average.

 

[rwmill9716]

Thanks, Straha.

The second formula is exactly what I needed.

ric