I would like to set up two cells that contain a begin number and an end
number representing a range of rows. I want to then concatenate a column
letter onto the start and end number so that I can average the values in the
range.
For Example:
If Column A contains values in rows 1 through 10 I would like to Name
"Start" equal to A11 and put 1 in A11 and Name "End" = A12 and put 10 in A12
and then do something like
=AVERAGE("A" & Start & ":" & "A" & End) to get the average of cells A1
through A10. I get #VALUE! indication