Skip To Main Content
Account
Settings
Logout
  • placeholder
Account
Settings
Logout
Filter:
Submit Search

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.

ClosedInputs

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.

ClosedOutputs

Returns

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


Copyright © 2025  |  Cognex Corporation  |  All Rights Reserved.

In-Sight Spreadsheet  |  2025 August 06  |  Revision: 25.2.0.129