Forum Discussion

AniB03-'s avatar
AniB03-
Copper Contributor
May 12, 2019
Solved

Define the reference cell as being always the above one, even when I copy/paste the row

I have the folowing formula for B2    =B1+A2  My rows go until for example 99, with the same formula on B column. But I sometimes Copy/Paste rows - for example row 2 to row 98. In this case, my form...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    May 12, 2019
    Select B2. While B2 is selected, press Ctrl+Alt+F3, enter CellAbove as the name, in the refers to box, enter this formula:
    =!B1
    Click OK.
AniB03-'s avatar
AniB03-
Copper Contributor
May 12, 2019

Twifoo 

Thank you for taking your time to answer me.

I copied in B2 your formula: =SUM(CellAbove,A2) but it returns ERROR. Thou I did not do anything with 

"Select B2. Define CellAbove with this formula:=!B1" part. What do you mean by: -Define CellAbove with this formula:=!B1?

Twifoo's avatar
Twifoo
Silver Contributor
May 12, 2019
Select B2. While B2 is selected, press Ctrl+Alt+F3, enter CellAbove as the name, in the refers to box, enter this formula:
=!B1
Click OK.
  • AniB03-'s avatar
    AniB03-
    Copper Contributor
    May 12, 2019

    Twifoo 

    Now, this is realy working, thank you!

    I also tried to do the same thing in Google SpreadSheets, but it is not working. 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 12, 2019
      You’re welcome.

Resources