Forum Discussion

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
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

SergeiBaklan

Diamond Contributor

Aug 22, 2022

rbd7436

You may use structured tables instead of ranges. It operates with "this row" and automatically expands the formula on all rows in the table.

With range, you may enter formula into the first cell of the column, select starting from that cell till end of the column and Ctrl+D

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
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
  Copper Contributor
  Aug 22, 2022
  Thanks for your help, SergeiBaklan !
  - SergeiBaklan
    Diamond Contributor
    Aug 25, 2022
    rbd7436 , you are welcome