Forum Discussion
sum row cells to another cell in same column
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
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
- 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).
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
Thanks for your help, SergeiBaklan !
