| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate row/column number in reference formula | Excel Worksheet Functions | |||
| Reference a number from a different column in a formula | Excel Worksheet Functions | |||
| How to use number in some cell as a part of other cells reference? | Excel Worksheet Functions | |||
| Formula for Increasing a Cell Reference by a Given Number | Excel Worksheet Functions | |||
| Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
Linear Mode
