Calculation Issues

Automatically Sum Columns C and D in Every Excel Table Row

Amos GikundaAmos Gikunda Nov 18, 2026 870 views

Question details

Calculate the sum of columns C and D in column E for every row, including new and inserted rows.

Automatically Sum Columns C and D in Every Excel Table Row
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a table

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.

2
Enter the sum formula

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.

3
Check the calculated column

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.

4
Add or insert rows

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.

Create an Excel Table with a calculated column
Use the actual table headers: The structured formula assumes the headers are literally Column C and Column D. The range between those headers includes any table columns between them.
Calculate row totals in WPS Spreadsheet

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. 1. Open the workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
  2. 2. Enter the formula: In the first total cell, such as E2, enter =SUM(C2:D2) and press Enter.
  3. 3. Fill existing rows: Select E2 and drag the fill handle down column E through the rows you want to calculate.
  4. 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.
Calculate each row's total with a SUM formulaOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

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.