← All questions

Apps & app stores

How do I add up a column of numbers in Google Sheets?

694.How do I add up a column of numbers in Google Sheets?

Your numbers are typed down a column — bills, spends, scores — and you want the total at the bottom. One short formula does it, and it keeps the total right when you correct a number later.

  1. Click the empty cell just under your last number — that is where the total will live.
  2. Type =SUM( — the equals sign first. It tells the sheet a sum is coming.
  3. Click the first number in the column.
  4. Hold the Shift key and click the last number. The sheet writes something like B2:B9 — every cell from the first to the last.
  5. Type ) and press Enter. The total appears.

On a phone: tap the cell under the numbers, and type the whole thing instead — =SUM(B2:B9) — using your first and last cells, then tap the tick. Change B2:B9 to match your own column.

Check it once: change any one of the numbers — add 10 to it — and watch the total grow by exactly 10. Change it back, and the total settles back too. A total that follows your numbers like that is a total you can trust. The full lesson — a whole household budget built cell by cell — is Google Sheets: The Grid That Adds Up for You.

In short: Click under the numbers → type =SUM( → click the first number → Shift-click the last → type ) → Enter.