Count the number of selections in multiple drop down lists in one cell.

Jamie6325

I am trying to count the number of selections (not caring what they select) in multiple drop down lists on multiple columns. Any example: If a person where to select 3 items from the drop down list in A2, and 4 items from the drop down list in B2, and 1 item from the drop down list in C2, I would want D2 to show 8.

I am tagging Paul as he seems to be an expert based on his other posts. :) @Paul Newcome

Paul Newcome

You would need to use the COUNTM function.

=COUNTM([Column A]@row) + COUNTM([Column B]@row)

Heather Duff

Hi @Jamie6325 ,

Try using COUNTM. For example:

=COUNTM([Column 1]@row:[Column 2]@row)

You would use the above if the columns are adjacent. If they aren't, you could use:

=COUNTM([Column 1]@row)+COUNTM([Column 2]@row)

Hope this helps! Let me know if it works.

Best,

Heather

Paul Newcome

You would need to use the COUNTM function.

=COUNTM([Column A]@row) + COUNTM([Column B]@row)

Heather Duff

Hi @Jamie6325 ,

Try using COUNTM. For example:

=COUNTM([Column 1]@row:[Column 2]@row)

You would use the above if the columns are adjacent. If they aren't, you could use:

=COUNTM([Column 1]@row)+COUNTM([Column 2]@row)

Hope this helps! Let me know if it works.

Best,

Heather

Jamie6325

I keep getting a syntex error. I didn't have to change the formula at all, correct? I literally just copied and pasted it in there.

Jamie6325

@Paul Newcome @Heather Duff

I keep getting a syntex error. I didn't have to change the formula at all, correct? I literally just copied and pasted it in there.

Heather Duff

@Jamie6325 You'll need to replace the column names (in [square brackets]) with your actual column names.

AaronJones

is there a simple way to omit one drop down selection from the total?

Paul Newcome

@AaronJones What do you mean?

AaronJones

Sorry I probably did a poor job of explaining but I figured it out. I was trying to create a column function that counted the number of elements in an adjacent cell with a column designation of "drop down list". I was able to use the COUNTM function combined with =IF to return zero for a given element I wanted omitted.