Content

• Steps
• Method 1 of 3: Writing a Sum Formula
• Method 2 of 3: Using AutoSum
• Method 3 of 3: Copying the SUM Function to Other Columns
• Tips

Using the Excel SUM function is an easy way to save time in calculations.

Steps

Method 1 of 3: Writing a Sum Formula

1. 1 Determine which column of numbers or words you want to add.
2. 2 Select the cell for the sum result.
3. 3 Write an equal sign followed by SUM. Like this: = SUM
4. 4 Write a link to the first cell, then a colon and a link to the last cell. Like this: = Sum (B4: B7).
5. 5 Hit enter. Excel will add the numbers in cells B4 to B7

Method 2 of 3: Using AutoSum

1. 1 If you have a column of numbers, use autosum. Click on the cell at the end of the list you want to add (below the numbers).
   • On Windows, press Alt + = at the same time.
   • On a Mac, press Command + Shift + T at the same time.
   • Or on any computer, you can click on the AutoSum button in the Excel menu / ribbon.
2. 2 Make sure the highlighted cells are the ones you want to sum.
3. 3 Press Enter for the result.

Method 3 of 3: Copying the SUM Function to Other Columns

1. 1 If you have multiple columns to add, hover over the bottom right of the cell with the result. The cursor changes to a cross.
2. 2 Hold down the left mouse button and drag it to the cells of similar columns, the amount of which you want to receive.
3. 3 Move the mouse over the last cell and release. Excel will automatically fill in the results of the sums of the selected columns!

Tips

• As soon as you start writing after the = sign, Excel will show a dropdown list of the available functions. Click on the function you want to use, in our case, on SUM.
• Imagine that the colon is a word HA, for example, B4 HA B7.