a relative row reference

  • Resolved polakr

    (@polakr)


    2 months, 4 weeks ago

    Hi, I have this problem: I need to sum the values ??from two other cells in the same row into one cell in a row. Ok, so I’ll write =A2+B2, for example. The problem is, when I move a row up or down in the table, the result starts to show nonsense, because the sum still takes values ??from cells A2 B2, even though it is the third row – it is the Excel equivalent of =$A$2+$B$2. I would need to do $A2+$A2. How do I do that please?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi!

    Thanks for your post and sorry for the trouble!

    For this, Excel’s INDIRECT() and ROW() functions should help. The latter can create a cell reference like A2 as a string, and the INDIRECT() formula then turns that string into an actual reference. Thus, please try this formula:

    =INDIRECT("A"&ROW())+INDIRECT("B"&ROW())

    Even when moving the row with this formula, the references will still refer the same cells in that row.

    Regards,
    Tobias

    Thread Starter polakr

    (@polakr)

    Thanks a lot for your help! I’m a maniac for football statistics and overviews, so I need tables often. Tablepress is by far the best plugin for working with tables!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.