The following formula will allow you to determine numeric values for more than one cell that aren’t in adjacent columns. If you don’t want to include all the cells in a range when you create a SUM function, Excel requires you to use the same formula, just with a minor adjustment. When you use your mouse to select a group of adjacent cells, you are also going to be selecting any hidden cells within that range of cells. Will the Sum Function Only Include Visible Cells? Since this will create the correct formula automatically you can see how it should look, which can help to determine where the error exists in the formula that you typed manually. If Excel is telling you that an error occurred after you include all of your values in the formula then you may want to try using your mouse to select the cell and enter the Autosum formula. So whether the values in the formula got there by you selecting the cells yourself or entering them manually, then the only thing that matters is whether all of the parts of the formula are correct. The Excel autosum will still sum numbers in your spreadsheet as long as the structure of the formula appears accurately. Can I Use the Sum Formula By Manually Entering Cell References?Īs we mentioned in the previous paragraph, you don’t need to rely on using your mouse to select cells for your autosum formula.
#HOW TO SUM A COLUMN IN EXCEL MANUAL#
Manual entry is a better option if you need to display the sum value in a cell that is not directly to the right of the row cells that you want to add. For example, in my example above, the formula would be =SUM(A3:G3). If you wish to manually enter the formula that adds your cells together, the formula is =SUM(XX:YY) where XX is the first cell, and YY is the last cell. Step 2: Use your mouse to highlight the cells for which you wish to find a sum. Step 1: Open your spreadsheet in Excel 2010. We are going to be using the buttons in the Excel ribbon for this method, but will also type out the formula that you can use if you prefer that option. The SUM feature is pretty diverse and is capable of adding together any values that you might need. You can apply this same method for adding cell values in a column as well, and you can make some minor adjustments if you need to add values in cells that are not consecutive to one another. This article is going to focus specifically on finding the sums of values contained within one row.
#HOW TO SUM A COLUMN IN EXCEL HOW TO#
How to Quickly Add the Sums of Cell Values in a Row in Excel 2010 (Guide with Pictures) Our guide continues with additional information on how to use the sum formula in Excel 2010, including pictures of these steps. 6 Additional Sources How to Find the Sum of a Row in Excel 2010