Totaling Numbers With SUM

Imagine a column of ten sales numbers. You could write =A1+A2+A3 and so on, but that gets long and easy to mistype. Spreadsheets give you a faster tool: the SUM function.

SUM adds up a whole group of cells in one short formula. Instead of listing every cell, you point SUM at a range and it totals everything inside.

In this lesson you will learn to total any list of numbers with a single, clean formula.

A function is a built-in shortcut for a common task. It has a name (like SUM) followed by parentheses that hold the arguments you give it.

The shape is always the same:

• = tells the spreadsheet to calculate
• SUM is the function name
• (A1:A10) is the argument inside parentheses

Every function follows this =NAME(arguments) pattern, so once you learn one, the rest feel familiar.

The simplest form of SUM takes one range:

=SUM(range)

A range is two cell addresses joined by a colon. A1:A10 means every cell from A1 down to A10, including both ends. SUM adds the numbers in all of those cells.

Spaces and blank cells are ignored, and text values are skipped, so SUM focuses only on the numbers it finds.

Suppose cells B2 through B6 hold weekly sales:

• B2 = 100
• B3 = 250
• B4 = 175
• B5 = 300
• B6 = 125

Typing =SUM(B2:B6) returns 950. The spreadsheet looked at all five cells, added them, and showed one total.

If you later change B3 to 250 from 200, the total updates instantly. That is the power of formulas: they recalculate automatically.

You do not have to type the range by hand. After typing =SUM(, click the first cell and drag down to the last cell. The spreadsheet fills in the range for you.

This is often safer than typing, because you can see exactly which cells are highlighted before you press Enter.

When the highlight matches the numbers you want, type the closing ) and press Enter to finish.

Sometimes you want to total every value in a column, even rows you have not filled yet. You can reference the entire column:

=SUM(D:D)

This adds every number in column D. New entries you type later are included automatically, which is handy for growing lists.

Just be careful not to place this total inside column D itself, or you create a circular reference where the cell tries to add itself.

Real data is messy. A column might have a header word, a few blank rows, or a note typed in by hand. SUM handles this gracefully.

If you write =SUM(A1:A10) and A1 contains the text "Sales", SUM simply skips it. Blank cells count as nothing. Only actual numbers are added.

This means you can safely include a header cell in your range without breaking the total.

SUM works horizontally too. If a row holds monthly figures across columns, point SUM at that row:

=SUM(B2:M2)

This adds the twelve cells from B2 to M2, perfect for a yearly total at the end of a row.

The colon range works in any direction. As long as the cells line up in a straight block, SUM can total them.

A small shop tracks daily revenue for a week in cells E2 through E8. The values are 420, 380, 510, 295, 600, 720, and 650.

The formula =SUM(E2:E8) returns 3575, the week's total revenue.

Without SUM you would chain seven additions and risk a typo. With SUM, one short formula does the work and stays correct even if a daily figure is edited.

Good news: SUM works identically in Microsoft Excel and Google Sheets. The syntax =SUM(range) is the same in both.

Most of the everyday functions you will learn behave the same way across both programs. When a function differs, we will point it out.

For SUM, you can move a sheet between Excel and Google Sheets and the totals keep working without any changes.

Watch out for two easy slips:

• Forgetting the equals sign. Typing SUM(A1:A10) shows the text instead of a total.
• Wrong range. =SUM(A1:A9) when your data runs to A10 quietly leaves out the last number.

Always glance at the highlighted range and check that the first and last cells are correct before pressing Enter.

Test your understanding of the SUM function.

You learned to total numbers fast with the SUM function:

• Use the pattern =SUM(range), for example =SUM(A1:A10).
• A range like A1:A10 means every cell from the first to the last.
• SUM ignores text and blank cells, adding only numbers.
• It works on columns, rows, and whole columns, and behaves the same in Excel and Google Sheets.

Next, you will find the average of a range instead of the total.