How to Add Up Columns in Microsoft Excel: Quickly Sum Numbers

PDF download Download Article

Add values for an entire column or range

PDF download Download Article

This wikiHow will show you how to sum columns in Microsoft Excel for Windows or Mac. Use the AutoSum feature to quickly and easily find the total sum of a column’s values. You can also make your own formula using the SUM function! We’ll cover how to add the values of individual columns and entire cell ranges.

Things You Should Know

  • Go to Formulas > AutoSum to automatically add up a column.
  • Use the SUM function to add individual or multiple columns.
  • To add multiple columns, select the cell range containing each column you want to sum.
Method 1
Method 1 of 6:

Using AutoSum for One Column

PDF download Download Article
  1. For example, if you have values in cells A1 through A5, you would click A6. [1]
  2. This will display various formula options in the top bar.
    Advertisement
  3. This will open a drop down menu with AutoSum options.
  4. This will automatically create a SUM function that adds the values of the column. You’ll see the values that are going to be summed in a highlighted selection box.
  5. This will confirm the SUM formula and show you the sum total in the cell you selected.
    6. Advertisement
Method 2
Method 2 of 6:

Using SUM for One Column

PDF download Download Article
  1. Doing so will place your cursor in the cell. This method uses the SUM function , which adds all of the values in a given cell range.
  2. Type =SUM() into the cell.
  3. Type the top cell in the column, a colon, and the bottom cell in the column into the parentheses.
    • For example, if you're adding values in the A column and you have data in cells A2 through A10 , you would type in the following: =SUM(A2:A10)
    • If your dataset has a header row, don’t include the header in the SUM formula.
  4. This will display the sum of the column in your selected cell.
  5. You can create SUM formulas for each column, or copy the first formula:
    • To quickly sum other columns of the same length, you can press Ctrl + c (Windows) to copy the cell with the SUM formula, then press Ctrl + v (Windows) to paste it under the other columns.
      • On Mac, these shortcuts are ⌘ Cmd + c and ⌘ Cmd + v respectively.
      • Pasting the formula will automatically change the cell references to the column that corresponds with where you pasted the formula.
    6. Advertisement
Method 3
Method 3 of 6:

Using SUM for Multiple Columns

PDF download Download Article
  1. This method adds up multiple columns in one formula. In order to include all of the cells in the longest column, you'll need to know to which row the column extends.
    • For example, if you have three columns and the longest one has values from row 1 through row 20, your formula will need to include rows 1 through 20 for each column you want to add even if this includes blank cells.
  2. If you're adding the A column and the B column, for example, your beginning column is the A column and your ending column is the B column.
  3. Click the cell in which you want to display the sum of your columns.
  4. Type =SUM() into the cell.
  5. For a range of cells, the left cell in the range is the top-left cell, and the right cell is the bottom-right cell. These two cells define the range.
    • In other words, type the first column letter, the first row number, a colon, the last column letter, and the last row number.
    • For example, if you're adding columns A, B, and C, and your longest column stretches to row 20, you would enter the following: =SUM(A1:C20)
  6. Doing so will display the sum of all of the columns in your selected cell.
    7. Advertisement
Method 4
Method 4 of 6:

Using SUMIF

PDF download Download Article
  1. Doing so will place your cursor in the cell. This method uses the SUMIF function, which allows you to add values in a data range if they meet a certain criteria. [2]
  2. Type =SUMIF() into the cell.
    • SUMIF has three arguments: range, criteria, [sum_range]. The [sum_range] argument is optional and used to specify a different range to sum values in. The criteria argument will check the range specified in the first argument.
  3. Type the top cell in the column, a colon, and the bottom cell in the column into the parentheses.
    • For example, if you're checking the values in the A column and you have data in cells A2 through A10 , you would type in the following: =SUMIF(A2:A10,)
    • If your dataset has a header row, don’t include the header in the SUM formula.
  4. Place the criteria as the second argument after the comma. This can be a cell reference, text, number, expression, or function. Each cell in the specified range will be checked using this criteria. If the criteria is met, it will be added to the total sum. Here are a few examples:
    • =SUMIF(A2:A10, 7) would check whether a value equals 7.
    • =SUMIF(A2:A10, "<10") would check whether a value is less than 10. Note that logical criteria needs quotation marks.
    • =SUMIF(A2:A10, "cat") would check whether the value is the word "cat".
  5. Place a comma after the criteria argument, then type a sum range. The sum range needs to be the same shape and size as the range in the first argument. SUMIF will check the criteria in the range and add the corresponding value in the sum range.
    • For example, if you had 9 purchases in A2:A10 and their corresponding prices in B2:B10, you could sum the prices of purchase called "food" using this formula:
    • =SUMIF(A2:A10, "food", B2:B10)
  6. This will display the sum in your selected cell.
    7. Advertisement
Method 5
Method 5 of 6:

Using the Status Bar

PDF download Download Article
  1. This is the letter header located above the spreadsheet cells. The entire column will be highlighted.
  2. At the bottom of Excel is the status bar. The sum total of the values in the column will be displayed next to "sum:".
    3. Advertisement
Method 6
Method 6 of 6:

Using a Table

PDF download Download Article
  1. Click and drag from the top left to the bottom right of your dataset to select it. This method changes the dataset into a table, to which you can add a total row. [3]
  2. It's at the top of the Excel window.
  3. A drop down menu will appear with table options.
  4. You can select from a variety of colors and formats. A small window titled "Create table" will appear after selecting a style.
  5. If your dataset has a header row, select this option to format the table correctly. Otherwise, uncheck the box.
  6. This will change the dataset into a table.
  7. It's at the top of the Excel window.
  8. This is an option in the "Table Style Options" section of the Table Design tab. [4]
  9. A drop down arrow will appear next to the cell. For example, if your data is in A2:A10 and the total row is in row 11, you would click A11.
  10. This will display a down down menu with total options.
  11. This is an option in the total drop down menu. A sum total for that column will appear in the cell. You're done!
    12. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I copy a formula?
    Community Answer
    Right click on the cell with the formula, select "Copy," and then paste the formula into the desired cell. Keep in mind you may have to manipulate the formula in the new cell if the columns are not the same length.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 2
  • Question
    How do I multiply two cells?
    Community Answer
    To multiply two cells use the * key to multiply by pressing shift 8, and type it in the cell you want, e.g. A1*B5.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 1
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • To total up a single column, you can enter the column's first value, a colon, and the last value into the SUM command. For example, to add cells A1, A2, A3, A4, and A5 together, you would type =SUM(A1:A5) into an empty cell.
        Thanks
        Helpful 0 Not Helpful 0
      • For an advanced Excel function, check out our guide on using VLOOKUP .
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • Changing a column cell's contents will cause the cell in which you're displaying the columns' total to change its value as well.
        Thanks
        Helpful 1 Not Helpful 0
      Advertisement

      You Might Also Like

      How to
      Find Duplicates in Excel
      How to
      Create Pivot Tables in Microsoft Excel to Analyze Data
      How to
      Create a Timeline in Excel: SmartArt, Templates, and More
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706
      2. ↑ https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
      3. ↑ https://support.microsoft.com/en-us/office/create-a-table-in-excel-bf0ce08b-d012-42ec-8ecf-a2259c9faf3f
      4. ↑ https://support.microsoft.com/en-us/office/add-a-total-row-to-a-table-9885a56c-51b5-487a-a168-054afd034631

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 251,466 times.

      Is this article up to date?

      Advertisement