> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Count

> Use the Sigma Count function to return the number of non-Null and non-empty values within a column or group.

The **Count** function returns the number of non-Null and non-empty values within a column or group.

The **Count** function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see [Group columns in a table](/docs/create-and-manage-tables#group-columns-in-a-table).

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see [Add summary statistics to a table](/docs/create-and-manage-tables#add-summary-statistics-to-a-table).

To learn more about using aggregate functions, see [Building complex formulas with grouped data](https://www.sigmacomputing.com/resources/training-videos/table-grouping-and-functions#complex-formulas).

## Syntax

`Count([Field])`

Arguments:

* **Field** (optional) The column of values to be counted. Null values are skipped.
  * If not supplied, `Count()` returns the number of rows in a table.

## Examples

`Count()`

* Counts number of rows in a table.

`Count([Funding Total Usd])`

* Counts number of companies with a disclosed funding total.

## Related resources

* [CumulativeCount](/docs/cumulativecount)
* [MovingCount](/docs/movingcount)
* [CountIf](/docs/countif)
* [CountDistinct](/docs/countdistinct)