How to Sum Multiple Rows and Columns in Excel

PDF download Download Article
Tips to quickly sum a column or row of numbers on Excel
PDF download Download Article

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.

How Do You Sum 2 Different Rows or Columns on Excel?

Insert a blank column or blank row after your data, then use your mouse to highlight the data you want to sum. Hit AUTOSUM on the Home tab, or press the keyboard shortcut to sum the numbers.

Method 1
Method 1 of 2:

Using the AUTOSUM Function

PDF download Download Article
  1. 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. Include the blank column or row in your selection.
    Advertisement
  3. Once you do the AUTOSUM calculation, the results will appear in the blank column or row after your data. [1] 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.
    4. Advertisement
Method 2
Method 2 of 2:

Using the SUM Function

PDF download Download Article
  1. 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. 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. To do this, type =SUM( .
  4. 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. 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. 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.
    7. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Link Sheets in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706#ID0EBBF=Windows

      About This Article

      Article Summary X

      1. Insert a blank column or blank row after your data.
      2. Highlight the data you want to add with your mouse.
      3. Press Alt + = on Windows, or Shift + Command + T on a Mac.

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 66,406 times.

      Is this article up to date?

      Advertisement