Use this function to count the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.
Sample Usage
COUNTM([Assigned To]:[Assigned To])
Syntax
COUNTM(
-
search_range1
- [
]
- search_range2
- ...
- search_range1—The cell reference or range to count within
- —[optional]
- search_range2
- ...
Additional values or ranges to count
Examples
This example references the following sheet information:
Given the table above, here are some examples of using COUNTM in a sheet:
| Formula | Description | Result |
|---|---|---|
| =COUNTM([Assigned To]3) | Count the number of values in the third row of the Assigned To column | 2 |
| =COUNTM(Choices:Choices) | Count the number of values in the Choices column | 6 |
| =COUNTM([Assigned To]:[Assigned To], Choices:Choices]) | Count the total number of values in both the Assigned To and Choices columns | 10 |
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.