SUM Function

The SUM Function is a quick and easy way of adding up individual figures or lists of figures in Excel.

What it does…

Adds up individual cells or ranges of cells.









To use the SUM function in Sheets,

  1. Click on the cell where you want the answer

  2. Click on AutoSum (the Greek letter sigma – looks like a backwards E)

  3. Choose SUM

  4. Press Enter


In Excel, click into the cell where you want your answer and press Alt + =

Note – SUM ignores empty cells and cells containing text .

Just Click Here Sum Function in Sheets gif - shows that text is ignored
SUM ignores empty cells and cells containing text .

Click on the download button above, if you want to download a copy of the example used. You will be asked if you want to make a copy of the spreadsheet. Click on Make a copy. A copy will then download into your Google Drive

The SUM function is usually the first (and sometimes the only!) function people use in a spreadsheet. Other useful functions in Sheets include MAX, MIN and AVERAGE. To return to the resources page, just click here.