View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I reference a cell as a row number in a formula?

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

"wileye" wrote in message
...
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?