Function Problems

How to Add Two Columns for Every Row in Excel

Jason MillerJason Miller Nov 18, 2026 870 views

Question details

Calculate the sum of columns B and C in column A for each row in a range.

How to Add Two Columns for Every Row in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to add values in columns B and C for rows 8 through 150 and display each row's result in column A.
Observed behavior
Each cell in column A should show the sum of the values in columns B and C on the same row.
Before you start

Identify the first and last rows of your data and make sure column A is available for the results. The examples below use rows 8 through 150; adjust the row numbers to match your worksheet.

Solution 1Recommended

Fill a Row-by-Row Addition Formula Down Column A

Use this method in a standard worksheet when you want a separate formula for each row.

1
Enter the first formula

Select cell A8, type =B8+C8, and press Enter.

2
Fill the formula down

Select A8:A150, then press Ctrl+D to fill the formula down. Alternatively, drag the fill handle from the lower-right corner of A8 down to A150.

3
Check the results

Select a cell such as A9 and check the formula bar. It should show =B9+C9, with references adjusted to that row.

Fill a Row-by-Row Addition Formula Down Column A
Add columns in WPS Spreadsheets

Add Two Columns Row by Row in WPS Spreadsheets

Use a simple addition formula in WPS Spreadsheets and fill it down to calculate each row's total.

  1. 1. Open your workbook: Open WPS Spreadsheets and select Open to choose your workbook.
  2. 2. Enter the formula: Select A8, type =B8+C8, and press Enter.
  3. 3. Fill the results down: Select A8 and drag its fill handle down to A150. Adjust the ending row to match your data.
  4. 4. Save the workbook: Select File > Save to save your changes.
Calculate row-by-row sums with a familiar formulaOpen and edit Microsoft Excel XLSX and XLS filesFill formulas down without retyping them for each row
microsoft office alternative - wps office

Frequently Asked Questions

How do I add columns B and C starting on a different row?

Enter a formula using that row's references in column A. For example, enter =B2+C2 in A2, then drag the fill handle down to the last data row.

Why does my dynamic array formula show #SPILL!?

A cell in the intended output range may contain data. Clear any blocking content in A8:A150 and check the formula in A8 again.

Can I use SUM instead of the plus sign?

Yes. Enter =SUM(B8:C8) in A8 and fill it down. SUM ignores text in referenced cells, while the plus operator may return an error for text values.

Do I need Microsoft 365 to fill a formula down?

No. Enter =B8+C8 in A8 and use the fill handle or Ctrl+D to copy it down in a standard Excel worksheet. The spilling range formula requires dynamic array support.