Aggregate functions
Aggregate keywords operate on the consecutive non-empty calculator lines above them.
Sum and total
| @1 | 10 | |
| @2 | 20 | |
| @3 | 30 | |
| @4 | total |
Average
| @1 | 10 | |
| @2 | 20 | |
| @3 | 30 | |
| @4 | average |
Minimum and maximum
| @1 | 8 | |
| @2 | 3 | |
| @3 | 21 | |
| @4 | min | |
| @5 | max |
Other supported aggregate keywords include count, median, and mode.
How aggregate lines are evaluated
Place an aggregate keyword directly below the values you want to summarize. Calcul.io reads upward through the consecutive non-empty lines, stops at the first blank line, and returns the result on the aggregate line. A blank line therefore acts as a boundary between separate groups of values.
Because every input remains visible, you can add, remove, or edit a value and see the total or statistic update in context. Use total for a sum, average for the arithmetic mean, min and max for the range endpoints, or count to report how many values are in the current group.
For additional operations and function syntax, browse the statistics functions or the complete function reference.