Count

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

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 Functions

Was this page helpful?
Yes No