Ulet-gebruikershandleiding

Aan de slag met Ulet voor Windows.

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

  1. Open your working expense workbook and select the Expenses worksheet.

  2. Select B7, beside the Total label.

  3. Replace the cell contents with =SUM(B2:B6).

  4. Press Enter, then select B7 again to inspect the completed formula.

English expense worksheet with B7 showing 100 and the formula bar showing SUM of B2 through B6

View screenshot at full size

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.

Ulet

Je complete kantoorpakket voor het dagelijkse werk.

Functies bekijken