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
Okay so i have 6 columns, FD, FE, FF, FG, FH, FI, and the values in each column is either 0 or 1.
I want that the next column; FJ adds the values from the 6 previous columns so that each row of FJ is the sum of the values on the same row (From FD to FI).
For example if on row 2, FD=1, FE=0, FF=0, FG=1, FH=1 and FI=1, I want the corresponding row in column FJ to add these numbers and show the number 4.
Since I have 9000+ rows in my dataset I need this to automatically apply to the following rows, so that each row of FJ sums the current row.
The first row is the name of each column/variable.
I hope this is enough info.
I want that the next column; FJ adds the values from the 6 previous columns so that each row of FJ is the sum of the values on the same row (From FD to FI).
For example if on row 2, FD=1, FE=0, FF=0, FG=1, FH=1 and FI=1, I want the corresponding row in column FJ to add these numbers and show the number 4.
Since I have 9000+ rows in my dataset I need this to automatically apply to the following rows, so that each row of FJ sums the current row.
The first row is the name of each column/variable.
I hope this is enough info.
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.
