Cell references within formulae
 

I want to reference a particular cell (call it N1018) from within an array
contained in a formula so that the starting row for the array is determined
by the number located within the cell N1018, e.g., the formula might read as
follows: =median(p(n1018):p37) where the value of N1018 is the row number
of cell p(N1018) That is, I want the formula to read =MEDIAN(p15:p37) if the
value in N1018 is 15. If the value of N1018 was 6, then the formula would be
=MEDIAN(p6:p37), etc.

Cell references within formulae
 

Try

=MEDIAN(INDIRECT("P" & N1018 &":P37"))

Mike

"Jodyeph" wrote:

I want to reference a particular cell (call it N1018) from within an array
contained in a formula so that the starting row for the array is determined
by the number located within the cell N1018, e.g., the formula might read as
follows: =median(p(n1018):p37) where the value of N1018 is the row number
of cell p(N1018) That is, I want the formula to read =MEDIAN(p15:p37) if the
value in N1018 is 15. If the value of N1018 was 6, then the formula would be
=MEDIAN(p6:p37), etc.