Returns the number of items in the list.
Sample usage
COUNT(Products[Color])
: The total number of (possibly duplicate) values in the Color
column of the Products
table. Equivalent to COUNT(SELECT(Products[Color], TRUE, FALSE))
. See also: SELECT()
COUNT(SELECT(Products[Color], TRUE, TRUE))
: The total number of non-duplicate values in the Color
column of the Products
table.
COUNT(SELECT(Products[Color], IN([Color], {"Red", "Orange"})))
: The total number of (possibly duplicate) values in the Color
column of the Products
table where the Color
column value is either Red
or Orange
. See also: IN()
COUNT(Orders[_RowNumber])
: The total number of rows in the Orders
table. Note that this is not equivalent to MAX(Orders[_RowNumber])
, which doesn't account for empty (e.g., deleted) rows or a spreadsheet header row. See also: MAX()
COUNT([Discounts])
returns the count of the items in the Discounts
column value, where Discounts
is of type List
.
COUNT(LIST("Red", "Yellow", "Green"))
returns 3
COUNT(LIST())
returns 0
COUNT(LIST(""))
returns 1
Count select rows
Count orders with special delivery instructions that occur within a reporting period:
COUNT(
FILTER(
"Orders",
AND(
ISNOTBLANK([Special Instructions]),
([Date Done] >= [_THISROW].[Begin Date]),
([Date Done] < [_THISROW].[End Date])
)
)
)
FILTER("Orders", ...)
gets a list of row references (values of the key column) for select rows inOrders
.AND(..., ..., ...)
limits the results to only those rows that match all of the conditions.ISNOTBLANK([Special Instructions])
ensures only rows that contain special delivery instructions are counted.([Date Done] >= [_THISROW].[Begin Date])
limits the count to only rows with aDate Done
column value no earlier than the report'sBegin Date
column value.([Date Done] < [_THISROW].[End Date])
further limits the rows to those with dates before the report's end date.COUNT(...)
counts the number of items selected.
See also: AND()
, FILTER()
, ISNOTBLANK()
Common problems
COUNT(1, 2, 3)
- In this example, the arguments are not in list form. To fix, wrap them in LIST()
to construct a list: COUNT(LIST(1, 2, 3))
.
Syntax
COUNT(list)
list
- List of any type.