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.

Earlier total lines don’t count again, so a total below a subtotal adds up the numbers, not the subtotal:

Notes CalculatorCopy

Calculation example

Calculation	Result
11	1
22	2
33	3
4total	6
55	5
6total	11
7average	2.75

Totals of durations keep the breakdown:

Notes CalculatorCopy

Calculation example

Calculation	Result
11 hour	1 hour
230 min	30 minutes
345 min	45 minutes
4total	2 hours 15 min

To add up a block of lines that spans empty lines or headings, use a line range like line2...line6.

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).