Calculate a Total with SUM on Windows
The SUM function adds numeric values in a range. In the Riverside expense workbook, five amounts appear in B2:B6 and the Total row is row 7. The five values add up to 100.
For matching example data, use the Practice workbook section at the end of this guide.
Enter the total formula
Open your working expense workbook and select the Expenses worksheet.
Select B7, beside the Total label.
Replace the cell contents with =SUM(B2:B6).
Press Enter, then select B7 again to inspect the completed formula.

The formula bar shows the calculation while the selected worksheet cell displays its result.
Check the range
The colon in B2:B6 means every cell from B2 through B6. The header in row 1 and the formula cell B7 are outside that range. Including B7 in its own total would create a circular reference.
For this sample, the amounts are 12, 8, 45, 15, and 20. Their sum is 100. Inspect the intended input cells if a total differs from what you expect, especially after adding another expense row.
Keep the formula
Press Ctrl+S to save. Reopen the file and select B7: the cell should still contain the formula, with its calculated result displayed in the grid.
Practice workbook
To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.
Item | Amount | Category | Owner | Status |
|---|---|---|---|---|
Paper | 12 | Supplies | Alex | Complete |
Pens | 8 | Supplies | Sam | Complete |
Desk lamp | 45 | Equipment | Jordan | Planned |
Notebook | 15 | Supplies | Alex | Planned |
Storage box | 20 | Equipment | Sam | In progress |
Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.
Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

