How to Find the Sum of a Row in Excel 2010

Many people who just casually use Microsoft Excel find that it is a great tool for organizing data. But it is very helpful for comparing data, and for performing mathematical operations on that data. One of the most common features in excel is the SUM function, which will add together a number of cells that you select. These cells can be from anywhere on your spreadsheet, including all of the cells that are contained in a row. So if you need to find the sum of cell values in a particular row, you can follow the steps outlined below.


How to Quickly Add the Sums of Cell Values in a Row in Excel 2010

This article is going to focus specifically on finding the sums of values contained within one row. 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. The SUM feature is pretty diverse, and is capable of adding together any values that you might need. 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.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Use your mouse to highlight the cells for which you wish to find a sum.

select the cells that you want to add together



Step 3: Click the Home tab at the top of the window.

click the home tab



Step 4:  Click the AutoSum button in the Editing section of the ribbon.

how to find the sum of a row in Excel 2010



The sum of the selected cells will be displayed in the cell to the right, as in the image below.

the sum will be inserted in the row to the right of the selected cells



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. For example, in my example above, the formula would be =SUM(A3:G3). 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.


If you have a Netflix or Amazon Prime account and you want to watch it on your TV, then the Roku LT is the simplest and most affordable option available. Click here to learn more about the Roku LT.

Learn how to compare values in columns in Excel 2010. newsletter
vintage t rex t-shirt

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