How to Sum Multiple Rows and Columns in Excel

Last Updated: November 1, 2021

This wikiHow teaches you how to use the AUTOSUM and SUM functions in Excel to quickly find the sums for multiple columns or rows. You'll also learn how to use the SUM function, which you can use to find the totals for multiple columns, multiple rows. You can also use the SUM function to find the sum of a single set of numbers that spans multiple columns and multiple rows.

Method 1

Method 1 of 2:

Using the AUTOSUM Function

1
Insert a blank column or blank row after your data. If want to find the sum of a set of rows, you'll want to have a blank row below the existing rows. If you are summing multiple columns, you'll need a blank column at the end of the existing columns. You can skip this step if you already have a blank column or row after your data.
- Insert a blank row: If you have data below the rows you want to add, right-click the row number below the place you want the blank row to appear and select Insert.
- Insert a blank column: If there is data in the column to the right of the rows you want to add, right-click the letter of the column to the right of where you want to insert the blank row and select Insert.
2
Use the mouse to highlight the data you want to sum. Include the blank column or row in your selection.

Advertisement
3
Press the keyboard shortcut for AUTOSUM. Once you do the AUTOSUM calculation, the results will appear in the blank column or row after your data.^{[1]
X
Trustworthy Source
Microsoft Support
Technical support and product information from Microsoft.
Go to source} The shortcut is different depending on your operating system:
- Windows: Press Alt + =
- macOS: Press Shift + Command + T
- You can also run AUTOSUM on the selected data by clicking the AutoSum option on the Formulas tab.

Method 2

Method 2 of 2:

Using the SUM Function

1
Insert a blank column or blank row after your data. First, if you want to find the total sum of an entire range of data that includes both columns AND rows, skip this step. If want to find the sum of a set of rows, you'll want to have a blank row below the existing rows. If you are adding multiple columns, you'll need a blank column at the end of the existing columns.
- Insert a blank row: If you have data below the rows you want to add, right-click the row number below the place you want the blank row to appear and select Insert.
- Insert a blank column: If there is data in the column to the right of the rows you want to add, right-click the letter of the column to the right of where you want to insert the blank row and select Insert.
2
Click the first blank cell after the numbers you want to add. If you're summing multiple columns, click the first blank cell after the last column (in the blank column). If you are adding multiple rows, click the first blank cell. If you're summing rows, click the first blank cell in the row below your data.
- If you're looking for the sum of a range of data that includes both columns and rows, just click the cell in which you want the sum to appear.
3
Type the beginning of the SUM formula. To do this, type =SUM(.
4
Select the numbers you want to add in the first row or column. To do this, use the mouse to highlight only the numbers in the first row or column of your data. This adds the range to the SUM formula.
- Don't include column headers or the blank row or column in your selection.
5
Type a closed parenthesis ) and press ↵ Enter or ⏎ Return. Once you do this, you'll have the sum of the first row or column in the formula cell.
- The formula should look something like this =SUM(A2:A8)
- If you highlighted a range of cells that includes multiple rows and columns, you now have the sum of all cells. You are done!
6
Drag the sum down the column or across the row. This runs the formula on the rest of the columns and rows. To do this, click the cell containing the formula once time. Then, drag the dark square at its bottom-right corner down or rightward to apply the formula to all columns or cells. Once finished, you'll see the sums of all rows or columns.