Forum Discussion
Summating multiple columns to a new column
Hi! I'm an Excel-beginner and need to know how to add a new column and in this I want 5 other columns to be summated. This feels like it should be simple but I can't make it work. /Emelie
Hi Emelie,
Many thanks for the hint. However, the formula in FJ2 in my case did not automatically apply to the rest of the cells under column FJ after I made my reference columns to be a table.
Why could this be the case please?
Select File > Options.
Select Proofing in the navigation pane on the left hand side.
Click AutoCorrect Options...
Activate the AutoFormat As You Type tab.
Make sure that the check box Fill formulas in tables to create calculated columns is selected.
Click OK, then OK.