How do I reference a cell as a row number in a formula?

  • Thread starter Thread starter wileye
  • Start date Start date
W

wileye

The formula I currently have is: =SQRT(SUM(F5280:F6240)/(N3-M3))
the row numbers 5280 and 6240 are values found in cells M3 and N3,
respectively.
However I need to copy this formula down a column, and I currently must go
through and edit each formula to change those two values to the neighboring
cells. i.e. that formula is in cell O3, and when copied to O4 the desired
rows of column F to be referenced will be the numerical values in M4 and N4.



=SQRT(SUM(F____:F____)/(N3-M3)) please fill in the blanks?
 
Try this:

=SQRT(SUM(INDIRECT("F"&M3&":F"&N3))/(N3-M3))

then copy it down as required.

Hope this helps.

Pete
 
Back
Top