Forum Discussion
Solved
Variable Range
I am trying to take the average of a range of cells, where the range is a variable. I have a long column of y-values vs. x-values. I would like to take the average of N-y values where N depends on ...
Hi,
You may use something like
=AVERAGE(OFFSET(A1,0,0,<height parameter>,<width parameter>))
where A1 is the first cell in your range to average, and the latest two are references on the cells which define the size of the range
Hi,
You may use something like
=AVERAGE(OFFSET(A1,0,0,<height parameter>,<width parameter>))
where A1 is the first cell in your range to average, and the latest two are references on the cells which define the size of the range
Thank you very much. I would not have figured this one out despite years of using Excel.