← 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:
- Type subjects in column A, and marks in column B, from row 2 down.
- Click an empty cell below the marks.
- Type
=SUM(B2:B8)and press Enter. That means “add everything from B2 to B8”. - 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
- SUM, Google Docs Editors Help.
- Mathematical Functions, LibreOffice Help.
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.
