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.
- 1Type = then the cells:
=B2*C2 - 2Press Enter: the cell shows 500, the formula bar shows the formula
- 3The small square at the corner is the fill handle
- 4Drag it down: the row numbers adjust by themselves
- 5
=SUM(D2:D5)adds the whole range - ✓Change a number and every total updates by itself