SamMail
Sign in
Help Center
SAM Office

Calculate totals and use formulas in SAM Count

2 min readLast reviewed: 5 November 2026Reference — live verification pending

Write a formula, total a range and use the Formulas tab to find functions.

This guide is based on application documentation. Its full procedure has not yet been tested directly; some details may vary by operating system and version.

Get SAM Office ↗

Step by step

  1. Enter 1200, 1500, 1400 and 1800 in B2:B5 of a test sheet. Keep B6 empty for the total.
  2. Select B6, type =SUM(B2:B5) and press Enter. B6 shows 5900; selecting B6 again shows the formula in the formula bar.
  3. Change B2 from 1200 to 1300 and confirm the edit. With automatic calculation enabled, the total updates to 6000.
  4. To calculate a difference, enter a cost in C2, select D2 and type =B2-C2. Press Enter to show revenue minus cost for that row.
  5. Open the Formulas tab and choose Function to open the Function Wizard. Search for a function, review its arguments and select the cells it should use.
  6. Check the wizard's result and confirm the formula. If a formula shows an error, reopen it in the formula bar or wizard and check the cell references and required arguments.
  7. Save the workbook. Review the totals against a few manual calculations before relying on them.

Inside the application

SAM Count 25.6 on macOS: a controlled budget example with a SUM formula. The table illustrates cells and formulas; its sample values differ from the written exercise. This is not a CSV import dialog.Select to enlarge ↗
Before you continue

Start a formula with =. A colon defines a continuous range: B2:B5 includes B2, B3, B4 and B5.

Function names and argument separators can follow your application settings. The Function Wizard helps insert the correct syntax.

If totals do not update, use Recalculate in the Formulas tab and check the referenced cells.

Still looking for an answer?

Contact the support team from your account and follow your request in the portal.

Contact support ↗
Calculate totals and use formulas in SAM Count
SAM Count example budget table with item quantities, unit costs, row totals and SUM(D2:D4) producing 112.