Count Multi Select dropdown values

Noble B

Good evening everyone! I’m looking for some help with a formula for Multi Select drop down. I’m looking to reference another sheet and count or sum the number of values selected in a drop down multi list regardless of what has been selected.

Thinh Huynh

Hi @Noble Bokilo

You can use COUNTM function to count multi select drop down as below

Hope that helps!

Noble B

@Thinh Huynh that did not work for me, i tried =COUNTM({Type}@row) since i'm referring to another sheet another sheet and got an error. "Type" is the multi select dropdown column in the other sheet i'm trying to refference.

Thinh Huynh

Let's say we have Sheet A that references to Sheet B as below

In Sheet A, I use =INDEX({Type B}; Number@row) in Type A column, then use =COUNTM([Type A]@row) in Count column

I mean to copy the Type B in sheet B to Type A in sheet A then count it in sheet A