# Count

Counts events over time. Starting at a specified integer (preset), the function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. adds one at each event trigger.
Returns the current running total.

Inputs

The Count function has the following syntax:

Count(Event, MaxValue, Reset, Preset)

See the table for a description of the available parameters.

Parameter | Description
Event | Specifies the event on which to increment the counter. This parameter needs to be a reference to any event with a timestamp, for example, one of the following: A cell containing an Event function. A cell containing a Button function.
Max Value | Specifies the highest value allowed before the counter automatically resets itself to the minimum Preset value. The default value is 9999999.
Reset | Forces the counter to reset to the Preset value.
0 = OFF (default) | The counter is allowed to reach the Max Value before it resets.
1 = ON | The counter resets at the next event trigger, even though the Max Value has not been reached.
Preset | First value at startup or value at reset. The default value is 0.

Outputs

Returns | An integer, which is the Preset value plus the number of events that occurred since the last reset.