Forum Discussion

rbd7436's avatar
rbd7436
Copper Contributor
Aug 22, 2022
Solved

sum row cells to another cell in same column

Sorry, I can't believe this is not already answered somewhere, but I can't find it.   I want the value in column E of any particular row to always be the sum of the values in columns C and D from t...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 22, 2022

    rbd7436 

    For the structured table it's enough to enter formula like

    in any row, it will be applied to all other rows (of course, if they were empty). Not necessary to type everything what is in formula bar, with using of arrow keys Excel helps to combine formula. "@" means "this row" Using structured references with Excel tables (microsoft.com)

     

    For the range enter formula in first cell and select from it  end of the column

    Ctrl+D

rbd7436's avatar
rbd7436
Copper Contributor
Aug 22, 2022
Thanks, but what is the formula that I need to enter in that first cell? I still don't know the magic character for "this row" (if there is such a thing).
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 22, 2022

rbd7436 

For the structured table it's enough to enter formula like

in any row, it will be applied to all other rows (of course, if they were empty). Not necessary to type everything what is in formula bar, with using of arrow keys Excel helps to combine formula. "@" means "this row" Using structured references with Excel tables (microsoft.com)

 

For the range enter formula in first cell and select from it  end of the column

Ctrl+D

  • rbd7436's avatar
    rbd7436
    Copper Contributor
    Aug 22, 2022

    Thanks for your help, SergeiBaklan !

Resources