How to Add Two Columns for Every Row in Excel
Question details
Calculate the sum of columns B and C in column A for each row in a range.

- 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.
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.
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.
Select cell A8, type =B8+C8, and press Enter.
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.
Select a cell such as A9 and check the formula bar. It should show =B9+C9, with references adjusted to that row.

Use a Dynamic Array Formula in Excel
Use a single formula to spill all results into column A when your Excel version supports dynamic arrays.
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. Open your workbook: Open WPS Spreadsheets and select Open to choose your workbook.
- 2. Enter the formula: Select A8, type =B8+C8, and press Enter.
- 3. Fill the results down: Select A8 and drag its fill handle down to A150. Adjust the ending row to match your data.
- 4. Save the workbook: Select File > Save to save your changes.

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.




