Automatically Sum Columns C and D in Every Excel Table Row
Question details
Calculate the sum of columns C and D in column E for every row, including new and inserted rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet needs a row-by-row total that extends automatically as data is added.
- Observed behavior
- Column E should show the sum of columns C and D for each existing and new table row without manually copying the formula.
Make sure columns C and D contain the values to add and column E is available for totals. Check the header names in columns C and D; structured references must match those names.
Create an Excel Table with a calculated column
Use a calculated column to apply the sum to existing rows and automatically extend it to new table rows.
Select the data range including columns C through E and their headers, then choose Insert > Table. Confirm the range and select My table has headers if applicable.
In the first data cell of column E, enter =SUM([@[Column C]:[Column D]]) and press Enter. Replace Column C and Column D with the actual headers in your table.
Confirm that Excel fills the formula down column E. If it does not, check File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and enable Fill formulas in tables to create calculated columns, then reenter the formula.
Add a row within the table, press Tab in the table's last cell, or enter data directly below the table. Check that the formula appears in column E of the new row.

Fill a row formula down a normal Excel range
Use this method if you do not want to convert the data to a table; new rows may require another fill.
Sum worksheet columns with WPS Spreadsheet
Open your workbook in WPS Spreadsheet, enter a row-total formula, and fill it down. If you use a table, check whether its formula extends to new rows in your version.
- 1. Open the workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
- 2. Enter the formula: In the first total cell, such as E2, enter =SUM(C2:D2) and press Enter.
- 3. Fill existing rows: Select E2 and drag the fill handle down column E through the rows you want to calculate.
- 4. Check new rows: Add a row and check column E. If the formula does not extend automatically, drag the fill handle into the new row.

Frequently Asked Questions
Why did my Excel Table formula not fill the whole column?
Check File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and enable Fill formulas in tables to create calculated columns. Then reenter the formula in a table data cell.
What should I use if my column headers are not named Column C and Column D?
Replace those names in =SUM([@[Column C]:[Column D]]) with the exact table headers for your two columns. Structured references use header names, not worksheet column letters.
Will the formula apply to a row added outside the table?
Only rows that become part of the table inherit its calculated column. Add data directly below the table or press Tab in its last cell, then check that the new row is included.
How do I sum the columns without creating a table?
Enter =SUM(C2:D2) in E2, select E2 through the desired last row, and press Ctrl+D. Repeat the fill when you add rows if the formula does not extend automatically.




