How To Sum Multiple Rows And Columns In Excel

Download Article

Download Article

This wikiHow teaches y'all 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 tin can use to discover the totals for multiple columns, multiple rows. You tin can also use the SUM part to find the sum of a unmarried set of numbers that spans multiple columns and multiple rows.

1. 1

   Insert a blank column or blank row later your data. If want to find the sum of a set of rows, you'll want to accept a bare row below the existing rows. If you are summing multiple columns, you'll need a bare column at the cease of the existing columns. Y'all tin skip this step if you already accept a blank column or row later on your information.

   • Insert a bare row: If you have data below the rows you want to add, correct-click the row number below the place you desire the blank row to appear and select Insert.
   • Insert a blank column: If there is data in the cavalcade to the right of the rows y'all want to add, right-click the letter of the alphabet of the column to the right of where you want to insert the bare row and select Insert.

2. ii

   Apply the mouse to highlight the information yous want to sum. Include the blank column or row in your selection.

   Advertisement

3. 3

   Printing the keyboard shortcut for AUTOSUM. Once you do the AUTOSUM calculation, the results will appear in the bare cavalcade or row after your data.^[1] The shortcut is dissimilar depending on your operating arrangement:

   • Windows: Press Alt + =
   • macOS: Press Shift + Control + T
   • You can also run AUTOSUM on the selected data by clicking the AutoSum choice on the Formulas tab.

   Advertizement

1. one

   Insert a blank column or blank row subsequently your data. Offset, if yous want to find the total sum of an unabridged range of data that includes both columns AND rows, skip this step. If want to notice the sum of a gear up of rows, you'll want to accept a bare row below the existing rows. If you are adding multiple columns, you lot'll need a blank column at the finish of the existing columns.

   • Insert a blank row: If y'all accept information beneath the rows you want to add, right-click the row number below the place you want the bare row to appear and select Insert.
   • Insert a blank column: If there is data in the cavalcade to the right of the rows you want to add, right-click the alphabetic character of the column to the right of where yous want to insert the bare row and select Insert.

2. two

   Click the showtime blank cell afterward the numbers you want to add. If you're summing multiple columns, click the beginning blank cell after the last column (in the blank column). If you are adding multiple rows, click the first blank cell. If yous're summing rows, click the first blank cell in the row below your data.

   • If you lot're looking for the sum of a range of data that includes both columns and rows, just click the prison cell in which you lot want the sum to appear.

3. 3

   Type the beginning of the SUM formula. To practice this, blazon =SUM(.

4. 4

   Select the numbers yous want to add together in the first row or column. To exercise this, use the mouse to highlight only the numbers in the showtime row or cavalcade of your information. This adds the range to the SUM formula.

   • Don't include column headers or the blank row or column in your selection.

5. v

   Type a closed parenthesis ) and printing ↵ Enter or ⏎ Return . Once you lot do this, you'll take the sum of the first row or cavalcade 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. 6

   Drag the sum downward the column or beyond the row. This runs the formula on the rest of the columns and rows. To practise this, click the cell containing the formula once time. And so, drag the nighttime square at its bottom-correct corner downwardly or rightward to apply the formula to all columns or cells. In one case finished, you'll see the sums of all rows or columns.

   Advert

Ask a Question

200 characters left

Include your email address to become a message when this question is answered.

Submit

Advertisement

About This Article

Article Summary X

1. Insert a blank column or blank row later your information.
2. Highlight the data you desire to add together with your mouse.
3. Press Alt + = on Windows, or Shift + Control + T on a Mac.

Did this summary help yous?

Thanks to all authors for creating a folio that has been read ii,433 times.

Is this article up to date?

Source: https://www.wikihow.com/Sum-Multiple-Rows-and-Columns-in-Excel

Posted by: daltonthisharm.blogspot.com

Share this post