Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found.
Sample Usage
COUNTM([Assigned To]:[Assigned To])
Syntax
COUNTM(
-
search_range1
-
[
- search_range2
- ...
-
search_range1—The cell reference or range to count within
-
- search_range2
- ...
Additional values or ranges to count
Examples
This example references the following sheet information:
Given the tableabove, here are some examples of using COUNTM in a sheet:
Formula | Description | Result |
---|---|---|
=COUNTM([Assigned To]3) | Count the number of values in the [Assigned To]3 cell | 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 |