Count

See also Strings > Length

Excel

=~COUNTA!~(‹range›) (counts all values in the array) OR =~COUNT!~(‹range›) (counts numbers in the range only)

=COUNTA(B:B) // {"ExCo",3,2,1} returns 4
=COUNT(C:C) // {"ExCo",3,2,1} returns 3

Tableau

~COUNT!~(‹field›)

COUNT([Customer ID])

Alteryx

Use the Summarize Tool (in the Transform palette):

(group by field, count by measure).

OrgVue

‹array›.~count!~ (counts all items in the array) OR ‹array›.~cnt!~ (counts numbers in the array only)

array("ExCo",3,2,1).count // Returns 4
array("ExCo",3,2,1).cnt // Returns 3
nodes().count 
// Returns the number of nodes within the current filter

tSQL

~COUNT!~(‹field›)

SELECT COUNT(CustomerID) 
FROM OrdersData

Python

~len!~(‹array›)

len(["ExCo",3,2,1]) # Returns 4

Last updated

Was this helpful?