0 of 62
Basics·Lesson 9 of 62Free

How to use SUM in Google Sheets

Add up a column

How SUM works

SUM adds up every number in a range.

SUM(range)
Example on this data
=SUM(F2:F4)→355

Adds the prices in rows 2 to 4.

What you’ll do

You’re looking at a small table of furniture orders. Your job is to add up the Units column into one total in K2. Totals like this are the first thing most people build in a sheet, and they update by themselves when the data changes.

Build it, step by step

  1. 1
    Start the formula

    Click K2 and type =SUM( Every formula starts with =, then the function’s name and an open bracket.

  2. 2
    Pick the cells
  3. 3
    Close it and press Enter

Your formula goes in K2.

K2
ABCDEFGHIJK
1OrderRepRegionProductUnitsPriceOrder dateShip date
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

The first 18 lessons are free. Pro unlocks the other 44, including a real-world scenario for every section and five closing projects.

See Pro, $49.99 once