Totals and Subtotals

Method	Name	Behaviour
total or sum	Total	Returns the sum of all previous consecutive numbers
average or avg	Average	Returns the average of all previous consecutive numbers
previous or prev	Previous	Returns the number before the current line (defaults to 0)

Total

Notes CalculatorCopy

Calculation example

Calculation	Result
11	1
22	2
33	3
4total	6

The total command calculates the sum of all previous consecutive numbers.

With consecutive numbers, we mean that the total command will only sum the non-empty lines that come before it, and it will stop at the first empty line or a line that does not contain a number.

Notes CalculatorCopy

Calculation example

Calculation	Result
11	1
22	2
33	3
4total	6
5
64	4
72	2
8total	6

In the example above, the first total command sums the numbers 1, 2, and 3, while the second total command sums only the numbers 4 and 2, because it stops at the first empty line, making it to act like a subtotal.

Average

Notes CalculatorCopy

Calculation example

Calculation	Result
11	1
22	2
33	3
4average	2

Previous

Notes CalculatorCopy

Calculation example

Calculation	Result
11	1
22	2
33	3
4previous	3

Multi-argument forms

sum and avg are also available as ordinary multi-argument functions when you want to combine specific values rather than the previous consecutive lines:

Notes CalculatorCopy

Calculation example

Calculation	Result
1sum(1, 2, 3, 4)	10
2avg(10, 20, 30)	20

See the Functions page for the full list of multi-argument built-ins (min, max, clamp, median, stddev, and more).