How to Add Up a Column in Excel 2011

If you’ve ever used a calculator while you were putting data into a spreadsheet, you may be wondering if there is a faster method of how to add up a column in Excel 2011.

Fortunately, Excel has a number of tools available that you can use when you want to compare, sum, or otherwise mathematically evaluate your data.

Our tutorial continues below with information on how to use the AutoSum feature in Microsoft Excel.

How to Total a Column in Excel for Mac

  1. Open the spreadsheet.
  2. Click inside the cell under the data to add.
  3. Choose the Formulas tab.
  4. Select AutoSum.
  5. Make sure the selection is correct, then press Enter.

Our guide continues below with additional information on how to add up a column in Excel 2011, including pictures of these steps.

Excel 2011 is a great choice when you need to sort and organize data. But it can do much more than that, including giving you the option of performing mathematical functions on your data.

So if you have a column of data containing numbers that you want to add together, you can use a formula to add up those numbers and give you a total. The method below will teach you how to enter that formula in the cell where you want to display the added total.

Find out how to add columns in Excel using several different options that are available by default in Microsoft’s spreadsheet application.

How to Sum a Column of Data in Excel 2011 (Guide with Pictures)

The steps below are going to use the AutoSum function of Excel to automatically select the data in your column that you want to add up.

You can, however, enter the formula into a cell yourself. The format of that formula is =SUM(XX:YY), where XX is the location of the top cell that you want to add, and YY is the location of the bottom cell. For example, adding up the data in cells A1-A20 would require the formula =SUM(A1:A20).

Step 1: Open the spreadsheet containing the column of data that you want to add together.

Step 2: Click inside the cell under the column data that you want to add up.

In the image below, I am going to be adding up the data in column C

click the cell where you want to display the total

Step 3: Click the Formulas tab in the green bar at the top of the window.

click the formulas tab

Step 4: Click the AutoSum button.

how to add up a column of data in excel 2011

Step 5: Confirm that the selected data is what you want to add up, then press the Enter key on your keyboard.

confirm that the selection is correct, then press Enter on your keyboard

Now that you know how to add up a column in Excel 2011 you will be able to quickly calculate totals for a selected range of cells in your spreadsheet.

If you are having trouble identifying data in a large spreadsheet as you scroll down, then learn how to freeze the top row of a spreadsheet in Excel 2011.

Additional Sources

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.