Excel: add a column of numbers with SUM

Use this simple example for classroom resources or practice data. Check important totals against an independent calculation.

add a column of numbers with SUM

  1. Enter sample numbers in cells B2 to B6.
  1. Select an empty cell below them, such as B7.
  1. Type =SUM(B2:B6) and press Enter.
  1. Change one sample value and check that the total updates.
  1. For your real sheet, change the range to match your data. Confirm the first and last included rows, and check that numbers have not been stored as text.

If you still need help

Share the formula and an anonymised example with IT if the answer is wrong. Do not send a full pupil or finance spreadsheet when sample values show the issue. Use the school support desk and choose the closest request category. Never include passwords or sign-in codes.

Further help

Official help guide

Practical advice and common pitfalls
If SUM returns zero or an unexpected total, check whether cells contain text, currency symbols typed into values, or hidden spaces. Use the formula bar to inspect the selected range and check whether new rows fall outside it. Do not overwrite original pupil data while troubleshooting.

Before you begin

Make a copy before changing a shared spreadsheet. Confirm whether the first row contains headings and whether numbers are stored as numbers rather than text.

Check the result and troubleshoot

When sorting, select the entire data range so names and associated values remain together. Check formula results against a small manual example and preview printing before distributing a sheet.

When to contact school IT support

If the problem remains, include the article title, device type, approximate time, exact error wording and the checks already completed. Do not include passwords, sign-in codes or sensitive pupil information.

Still need help?

Send a request and include the steps you already tried.

Submit a ticket

Rate this article

How useful was this article?
Add a correction or suggestion (optional)
Do not include passwords, pupil details, or other private information.