Teach the Google Sheets SUM Formula Online With a Tiny Practice Dataset

Teach SUM through a small worksheet, predictable totals, one deliberate input change, and a range-extension exercise learners can explain.

Author profile photo

By

Share this article:TwitterLinkedIn

Illustration of a remote tutor and two adult learners comparing a small spreadsheet exercise with counters and notes

A learner who copies a formula and sees the expected number has completed the first step. For an online spreadsheet lesson, give them a second task: predict what will happen when one input changes, then check the result and explain the range.

Use a tiny worksheet whose arithmetic is easy to verify without software. This guide teaches one Google Sheets formula, SUM, through a worked example and two checks. Google Sheets handles the spreadsheet; Focus Room can provide website rules around the browser practice period. The teacher still reviews the learner's formula and explanation.

Start with three amounts and a known answer

Use a new practice sheet with fictional data, rather than a workplace budget or a learner's personal expenses. Put Item in A1 and Amount in B1. Enter these labels and numbers in separate cells:

A2: Notebooks     B2: 30
A3: Pens          B3: 20
A4: Folders       B4: 10
A5: Total         B5: (empty)

The numbers are arbitrary practice amounts, with no currency or real purchase implied. Ask the learner to calculate 30 + 20 + 10 before entering a formula. The expected total is 60. Keep that prediction in a separate note so the learner can compare it with the sheet's result.

Give each learner an editable practice copy or a separate practice area, using the sharing arrangements in your existing teaching tools. Check access before the lesson. A learner who can open a file but cannot edit it needs an access fix before formula practice can begin.

Explain the range before entering SUM

Ask the learner to select B5 and enter:

=SUM(B2:B4)

Google's SUM documentation describes the function as adding numbers or cells and shows range-based examples. Here, B2:B4 means the cells from B2 through B4, including B3. The equals sign starts the formula, and SUM adds the values in that range.

The result should be 60. Ask the learner to point to the three input cells and read the formula aloud. Then ask why B5 is outside the range: it holds the total, so the formula should add the input amounts without including its own result cell.

Keep the first explanation narrow. Formatting, charts, conditional sums, and large imported datasets can wait. The immediate goal is to connect a formula's selected cells with a result the learner can check.

Illustration of a learner arranging small stacks of counters beside a paper grid to check one changed amount

Change one input and predict the new total

Before touching the sheet, ask: “If the amount in B3 changes from 20 to 25, what should happen to the total?” The increase is 5, so the predicted result is 65.

Have the learner change B3 to 25 while leaving the formula in B5 unchanged. Check that B5 now shows 65. Then inspect the formula again: it should still be =SUM(B2:B4).

This separates two actions that can look similar on screen: calculating with a formula and typing a total manually. If B5 contains the number 60 instead of a formula, changing B3 will not turn that fixed number into 65. Ask what is stored in the total cell before proposing a repair.

If the result is unexpected, pause and check the inputs, the formula's first and last cells, and the location of the total. Compare those details with the original setup. Do not replace several values at once; that would make it harder to tell which correction mattered.

Finally, reset B3 to 20 and confirm the total returns to 60. State this reset explicitly before the next exercise, which starts from the original three amounts.

Add one amount and move the total

For a separate exercise, add a fourth item to row 5. Explain the change before learners overwrite the current total:

  1. Clear the old total formula from B5 and replace A5's label with Envelopes.
  2. Enter 5 in B5.
  3. Put Total in A6 and enter =SUM(B2:B5) in B6.

The inputs are now 30, 20, 10, and 5, so the expected result in B6 is 65. B6 stays outside the summed range. This exercise changes the formula explicitly; it does not depend on what the application might do when rows are inserted or moved.

Ask the learner to compare B2:B4 with B2:B5. Which new cell is included? What would the old range leave out? A clear answer names B5 and its value of 5.

For a final check, change B5 from 5 to 8 and predict 68. Check B6, then restore B5 to 5. A total of 65 again, together with the learner's explanation, gives you something concrete to review.

Illustration of a tutor and learner comparing a paper grid whose highlighted range extends to include another amount

Run the online practice with a clear resource plan

Demonstrate the first formula, then let learners type, predict, edit, and explain in their own practice area. In a small group, ask a partner to name the included cells before checking the total. Offer a spoken explanation or another suitable response format if typing the explanation creates an access barrier.

For a Focus Room session, allow the spreadsheet host and any required sign-in, lesson, or reference hosts. Test the complete learner route, including links that open on another domain. The website-blocking setup guide covers that preparation, and the student session guide explains joining.

Focus Room matches allowed hostnames and their subdomains in the participating browser while the extension is active. Allowing a spreadsheet host permits more than one worksheet on that host. It does not limit a learner to a single file or replace the spreadsheet's sharing permissions.

Focus Room does not read or execute formulas, grade the sheet, or show the teacher the learner's screen. It does not control desktop Excel, other browsers, phones, or desktop apps. Ask learners to explain or share their practice work through your existing lesson tools; browser events cannot establish spreadsheet understanding.

Close by asking for the final formula, the expected total, and one sentence about why that range is correct. End the Focus Room session when practice finishes. To try the routine, create a Focus Room account, prepare the small worksheet, and test the resource route before inviting learners.

    Teach the Google Sheets SUM Formula Online With a Tiny Practice Dataset | Focus Room Blog