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

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?

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?

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

Try this:

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

then copy it down as required.

Hope this helps.

Pete

On Dec 13, 6:38*pm, wileye wrote:
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?

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

Hi,

Try this

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

Mike

"wileye" wrote:

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?

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

Thank you! You just saved me several hours of editing each formula!

"Mike H" wrote:

Hi,

Try this

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

Mike

"wileye" wrote:

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?

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

Glad I could help and thanks for the feedback

"wileye" wrote:

Thank you! You just saved me several hours of editing each formula!

"Mike H" wrote:

Hi,

Try this

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

Mike

"wileye" wrote:

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?