How to Use the Sum Function in Microsoft Excel

Method 1 of 3:

Writing a Sum Formula

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

Method 2 of 3:

Using AutoSum

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.
Confirm that the highlighted cells are the ones you want to add up.
Press enter for the result.

Method 3 of 3:

Copying the Sum Function to Other Columns

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.
Hold down your left mouse button. Keep it held down as you drag it across all of the cells you wish to add.
Move your mouse pointer over the last cell, then let go of the button. Excel will AutoFill the rest of the formulas for you!

Marvin Fry

Update 05 March 2020

You should read it

May be interested

How to Integrate Large Data Sets in Excel
these instructions will show you how to approximate integrals for large data sets in microsoft excel. this can be particularly useful when analyzing data from machinery or equipment that takes a large number of measurements—for example, in ...
How to Make Tables Using Microsoft Excel
this wikihow teaches you how to create a table of information in microsoft excel. you can do this on both windows and mac versions of excel. open your excel document. double-click the excel document, or double-click the excel icon and then...
How to Create a Random Sample in Excel
this wikihow teaches you how to generate a random selection from pre-existing data in microsoft excel. random selections are useful for creating fair, non-biased samples of your data collection. open the microsoft excel program. you can...
How to Prevent Excel from Removing Leading & Trailing Zeros
excel automatically removes leading zeros, as well as trailing zeros after a decimal point. if this disrupts your ability to store data such as postal codes, you can import the data as text so it appears exactly as entered. if you need to...
How to Track your Bills in Microsoft Excel
many companies use microsoft excel to track department or overall company expenses. as excel is now frequently bundled with personal computers that use the windows operating system, if you have excel on your home computer, you can use it...
How to Use Macros in Excel
this wikihow teaches you how to enable, create, run, and save macros in microsoft excel. macros are miniature programs which allow you to perform complex tasks, such as calculating formulas or creating charts, within excel. macros can save...

How to Use the Sum Function in Microsoft Excel

Writing a Sum Formula

Using AutoSum

Copying the Sum Function to Other Columns

You should read it

May be interested

Office information