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

tSQL

~COUNT!~(‹field›)

Python

~len!~(‹array›)

Last updated

Was this helpful?