Horizon Icon

Using Functions

Horizon has five built-in functions, Sum, Count, Average, Maximum, and Minimum. Functions work over a range of dates in the same category. You tell Horizon about the range by giving it the first and last date in the range.
To use a function in a formula, enter the function name (sum, count, avg, max or min), then a left bracket '('. Click on the cell you want to start the range. Then enter a comma. Then click on the cell that ends the range. Now enter a right bracket ')'.

Function names are not case-sensitive; you can type 'sum', 'SUM', 'Sum', or any other combination of upper and lower case letters.

The range must start and end on the same category, and the function will only include cells in that category. An equation can include one or more functions, and reference cells on different categories.

function demo

See also

cells
Cell Topics