Excel Sum Multiple Columns: Formulas, Examples, and Tips

Formulas & functions · Updated November 18, 2026

To sum several columns in Excel, use =SUM(B2:D10) for one continuous block of cells. For separate columns or ranges, list each range inside SUM; for a total on every row, use a formula such as =SUM(B2:D2) and fill it down. The best choice depends on whether you want one grand total, row-by-row totals, or a total that meets a condition.

Choose the range that matches your goal

In Microsoft Excel for Microsoft 365 on Windows, SUM adds numbers from one or more cells or ranges. Think first about the shape of the result you need: a single number for an entire block, one total for each row, or totals for selected columns. Choosing the right range is more important than using a complicated formula.

Suppose a worksheet has sales in columns B, C, and D, with records in rows 2 through 10. With values in B2:D4 of 10, 20, and 5 in row 2; 7, 0, and 3 in row 3; and 8, 12, and 4 in row 4, the formula =SUM(B2:D10) returns 69, assuming the remaining cells in that range are blank. It adds all cells in the rectangle, not just the first and last columns. The colon in a range reference means “through,” so B2:D10 includes every cell from B2 to D10.

This approach is suitable when the columns are adjacent and you want one combined total. It also keeps the formula easy to update: if more records are added within the selected range, they are included. If new rows will regularly be added below the range, consider using an Excel Table so its data range can expand as records are entered.

Get one total for each row

A grand total and a row total answer different questions. If each row is a person, order, or month and you want the sum across that row’s columns, put the formula in an empty result column. With values 10, 20, and 5 in B2:D2, =SUM(B2:D2) returns 35. Enter it in E2, then use the fill handle at the lower-right corner of the cell to copy the formula down the records.

When copied from E2 to E3, the relative references adjust to B3:D3. This is usually what you want for a row total. To copy a formula, select the cell and drag its fill handle down, or copy it and paste into the destination cells. Check that the first and last rows are included; a missed row can make a total look plausible while still being wrong.

For a single total at the bottom of each column, use the same principle in the opposite direction: sum each column’s data rows separately. You can enter a formula below one column and copy it across adjacent result cells. Excel adjusts the column references when the formula is copied to the right.

Sum columns that are not next to each other

If the columns you need are separated by data you do not want to add, specify each range as a separate argument in SUM. For example, if B2:B4 contains 10, 7, and 8, and D2:D4 contains 5, 3, and 4, =SUM(B2:B4,D2:D4) returns 37. It leaves out column C.

The comma separates arguments in the formula. You can list individual cells as well as ranges, and you can combine ranges of different sizes when the goal is simply to add all their numeric values. For example, this is useful when one column contains sales and another contains a separate adjustment that belongs in the same total. Be deliberate about what each argument includes: adding a subtotal cell as well as the detail cells that produced it will count those values twice.

For a quick total of entire adjacent columns, a whole-column reference is possible. With numeric data only in B2:D4 and no other numeric values in columns B through D, =SUM(B:D) returns 69. Put this formula outside columns B:D; placing it in one of the columns it sums can create a circular reference. Whole-column formulas can also include unrelated numbers farther down the sheet, so a defined data range is safer when those columns contain notes, extra calculations, or other tables.

Sum the same columns across worksheets

When the same cell or range is laid out consistently on several worksheets, a three-dimensional reference can total across a continuous run of sheet tabs. Suppose sheets named Jan, Feb, and Mar each have a monthly total in B2, with values 120, 150, and 130. If those three sheets are next to one another in tab order, =SUM(Jan:Mar!B2) returns 400.

The reference includes B2 on every worksheet from Jan through Mar, including any sheets positioned between those tabs. This is convenient for a workbook with one identically structured sheet per month, but it can include an unexpected sheet if tabs are moved or inserted within that range. Review the tab order and the layout on each included sheet before relying on the total. If the worksheets are not consecutive, add individual sheet references as separate arguments instead.

Sum multiple columns when a condition applies

A common follow-up is how to add several amount columns only for rows that meet a criterion, such as a particular region. If categories are in A2:A4, and amounts are in B2:D4, you can add one SUMIF for each amount column and combine the results. For the example data above, let A2 and A4 contain East and A3 contain West. The East rows total 15 in column B, 32 in column C, and 9 in column D, for 56 overall. The formula =SUM(SUMIF(A2:A4,"East",B2:B4),SUMIF(A2:A4,"East",C2:C4),SUMIF(A2:A4,"East",D2:D4)) returns 56.

This method repeats the same criteria range and criterion while changing the sum range for each amount column. It is clear and dependable when there are only a few columns. For many columns, a more maintainable layout may be to arrange the data so each record has one amount column and use a PivotTable or a suitable conditional-total formula. SUMIFS is useful when a sum range has multiple criteria, but the sum range and criteria ranges need compatible dimensions; do not simply give a one-column criteria range and a wider multi-column sum range and assume it will total the whole block.

Handle filtered or hidden rows

SUM adds values in its referenced range even when some rows are hidden by a filter. That can surprise people who expect a displayed total to change when they filter a list. To total only visible rows in a filtered range, use SUBTOTAL with function number 109. With the example values in B2:D4, =SUBTOTAL(109,B2:D4) returns 69 when every row is visible. If a filter hides row 3, it returns 39, the total of rows 2 and 4.

Function number 109 makes SUBTOTAL ignore rows hidden manually as well as rows excluded by a filter. The related function number 9 ignores filtered-out rows but includes manually hidden rows. Use the version that fits how the worksheet is being used. A subtotal is not a replacement for a grand total in every situation: decide whether hidden records should count before choosing the function.

Use AutoSum for a fast total

AutoSum can insert a SUM formula based on nearby numbers. On Windows, select the empty cell below a column of numbers, then choose Home > Editing > AutoSum. Excel proposes a range; inspect the selection and press Enter to accept it. If the proposed range is incomplete or includes a heading or subtotal, edit the reference before accepting.

For adjacent columns, select the empty cells beneath those columns and choose AutoSum. Excel can insert a separate total for each column. Likewise, selecting an empty cell beside a row of numbers and using AutoSum can create a row total. AutoSum is a shortcut, not a different kind of calculation: it creates a normal SUM formula, which you can inspect and edit in the formula bar.

The Windows keyboard shortcut for AutoSum is Alt+=. In Excel for Mac, the corresponding shortcut is Command+Shift+T; the ribbon command is also available. Excel for the web has AutoSum on the Home tab, although the ribbon layout can vary with the window size. Whichever method you use, verify the highlighted range rather than assuming Excel selected exactly the intended cells.

Common problems and checks

  • A value is missing: Check whether the cell falls inside the referenced range. A formula that ends at row 20 will not include a new value entered in row 21.
  • A number is stored as text: A number-looking entry imported from another system may be text, which SUM generally ignores when it is inside a referenced range. Look for a warning indicator, inconsistent alignment, or a number format that does not behave like nearby values; convert the data to numeric values before trusting the total.
  • The result is unexpectedly large: Check for overlapping ranges, duplicated records, or a subtotal included alongside the detail that it already totals. Whole-column references can also pick up values outside the apparent data table.
  • The formula shows an error: A referenced error value, such as #VALUE! or #N/A, can cause the sum to return an error instead of a number. Find and correct the source error rather than masking it without understanding why it occurred.
  • Dates appear in a total: Excel stores dates as serial numbers, so a date included in the range is added as a number. Restrict the range to amount cells rather than mixing dates and quantities.
  • The formula text appears in the cell: Confirm that the cell is not formatted as Text, and check that Show Formulas has not been turned on. After correcting the format, re-enter the formula if necessary.

For dependable results, compare the formula’s selected range with the intended records, then do a quick independent check on a small sample. If rows represent transactions, compare the number of records included with the count you expect. Formatting a result as currency or a number changes how it displays, not the underlying calculation; choose a suitable number format after confirming the sum.

Frequently Asked Questions

How do I sum three columns in Excel?
For one total across adjacent columns, use a SUM range covering all three, such as =SUM(B2:D10). For a separate total on each row, sum across that row and copy the formula down.

Can I sum columns that are not adjacent?
Yes. Put each column or range you want to include into the SUM formula as a separate argument, separated by commas. Leave out the ranges that should not contribute to the result.

How do I total each row across multiple columns?
Enter a row range in a blank result cell beside the first record, then copy the formula down. Excel adjusts the row references for each copied formula, provided the references are relative.

Why does my sum not change when I filter the data?
SUM includes filtered-out rows. Use SUBTOTAL with function number 109 when the total should include only visible rows, including when rows have been manually hidden.

Can AutoSum add several columns at once?
Yes. Select the blank cells beneath adjacent columns and choose Home > Editing > AutoSum. Review the ranges Excel proposes; AutoSum may need adjustment if the data has gaps or nearby totals.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.