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 3Tableau
~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 4tSQL
~COUNT!~(‹field›)
Python
~len!~(‹array›)
Last updated
Was this helpful?