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
- Enter sample numbers in cells B2 to B6.
- Select an empty cell below them, such as B7.
- Type =SUM(B2:B6) and press Enter.
- Change one sample value and check that the total updates.
- 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
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.
Send a request and include the steps you already tried.