HomeApplicationOffice information

How to Use the Sum Function in Microsoft Excel

Using the SUM function in Excel is an easy way to save yourself lots of time. Decide what column of numbers or words you would like to add up
Method 1 of 3:

Writing a Sum Formula

  1. How to Use the Sum Function in Microsoft Excel Picture 1How to Use the Sum Function in Microsoft Excel Picture 1
    Decide what column of numbers or words you would like to add up
  2. How to Use the Sum Function in Microsoft Excel Picture 2How to Use the Sum Function in Microsoft Excel Picture 2
    Select the cell where you'd like the answer to populate
  3. How to Use the Sum Function in Microsoft Excel Picture 3How to Use the Sum Function in Microsoft Excel Picture 3
    Type the equals sign then SUM. Like this: =SUM
  4. How to Use the Sum Function in Microsoft Excel Picture 4How to Use the Sum Function in Microsoft Excel Picture 4
    Type out the first cell reference, then a colon, then the last cell reference. Like this: =Sum(A2:A4).
  5. How to Use the Sum Function in Microsoft Excel Picture 5How to Use the Sum Function in Microsoft Excel Picture 5
    Press enter. Excel will add up the numbers in cells A2 to A4
Method 2 of 3:

Using AutoSum

  1. How to Use the Sum Function in Microsoft Excel Picture 6How to Use the Sum Function in Microsoft Excel Picture 6
    To add a complete column or row of numbers, use AutoSum. Click into the cell at the end of the list you want to add (below or next to the given numbers).
    1. In Windows, press Alt and = at the same time.
    2. On a Mac, press Command and Shift and T at the same time.
    3. Or on any computer, you can select the Autosum button from the Excel menu/ribbon.
  2. How to Use the Sum Function in Microsoft Excel Picture 7How to Use the Sum Function in Microsoft Excel Picture 7
    Confirm that the highlighted cells are the ones you want to add up.
  3. How to Use the Sum Function in Microsoft Excel Picture 8How to Use the Sum Function in Microsoft Excel Picture 8
    Press enter for the result.
Method 3 of 3:

Copying the Sum Function to Other Columns

  1. How to Use the Sum Function in Microsoft Excel Picture 9How to Use the Sum Function in Microsoft Excel Picture 9
    Place your mouse pointer to the bottom right of the cell you just finished adding up, to add up multiple columns. The pointer will turn into a thick black cross.
  2. How to Use the Sum Function in Microsoft Excel Picture 10How to Use the Sum Function in Microsoft Excel Picture 10
    Hold down your left mouse button. Keep it held down as you drag it across all of the cells you wish to add.
  3. How to Use the Sum Function in Microsoft Excel Picture 11How to Use the Sum Function in Microsoft Excel Picture 11
    Move your mouse pointer over the last cell, then let go of the button. Excel will AutoFill the rest of the formulas for you!
5 ★ | 1 Vote
addcellsumpress

You should read it

Maybe you are interested

Office information