Free demo · Google Sheets · Lesson 2 · Basics · First formulas

Formulas, the fill handle and SUM

A formula starts with = and points at cells, not numbers. Write it once, drag it down, and add a total that updates by itself.

Item | Qty | Price | Total Notebooks | 50 | 10 | =B2*C2→500 T-shirts | 12 | 100 | =B3*C3→1,200 Pencils | 50 | 5 | =B4*C4→250 Water bottles | 20 | 20 | =B5*C5→400 | | | [b,hide]=SUM(D2:D5)→2,350
  1. 1Type = then the cells: =B2*C2
  2. 2Press Enter: the cell shows 500, the formula bar shows the formula
  3. 3The small square at the corner is the fill handle
  4. 4Drag it down: the row numbers adjust by themselves
  5. 5=SUM(D2:D5) adds the whole range
  6. ✓Change a number and every total updates by itself
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

Every Google Sheets formula starts with an equals sign and usually refers to cells rather than typed numbers, so the result updates whenever the data changes. Typing =B2*C2 multiplies the quantity by the price; the cell shows the result while the formula bar shows the formula. The fill handle, the small square at the corner of the selected cell, copies a formula down a column and adjusts its references row by row (relative references). The SUM function adds a range such as D2:D5, and selecting cells shows a quick sum at the bottom right of the window. The full course goes on to absolute references with the $ sign, AVERAGE, COUNT, MAX, MIN and ROUND, number formats and the meaning of every error message.

Key points

  • A formula starts with = and points at cells
  • The fill handle copies a formula and adjusts it
  • SUM adds a range and updates by itself