=LISTCOUNT
The =LISTCOUNT() function returns the total number of items in a semicolon separated list.
Syntax
Section titled “Syntax”=LISTCOUNT(Item1; Item2; Item3; Item4)Returns: 4
How It Works
Section titled “How It Works”-
Counts each item in a semicolon-separated list
-
Returns a numeric value representing the total number of items
-
Works with both field tokens and static list values
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be in ALL CAPS
Keywords
Section titled “Keywords”LISTCOUNT, count items, semicolon list, list length, number of items, list functions, text functions, formula function, calculated value