Skip to content

← Using a Computer, in Practice

Spreadsheets · 50 of 111

Add up a column with SUM

Expert guidance

Do this

Works the same in LibreOffice Calc, Google Sheets and Excel:

  1. Type subjects in column A, and marks in column B, from row 2 down.
  2. Click an empty cell below the marks.
  3. Type =SUM(B2:B8) and press Enter. That means “add everything from B2 to B8”.
  4. Change a mark, and watch the total change.

Why this way

Every formula starts with =. A cell name like B2 is its column and row, so the formula reads the cell, not the number. That’s the whole power of a spreadsheet: put each number in only once, and let it do the sums. There’s more in Computing, Reimagined. Expert guidance.

Do it today

Enter your last exam’s marks and total them. Five minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do