Count the number of selections in multiple drop down lists in one cell.
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
Best Answers

You would need to use the COUNTM function.
=COUNTM([Column A]@row) + COUNTM([Column B]@row)

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
Answers

You would need to use the COUNTM function.
=COUNTM([Column A]@row) + COUNTM([Column B]@row)

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

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.

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 You'll need to replace the column names (in [square brackets]) with your actual column names.

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

@AaronJones What do you mean?

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.
Help Article Resources
Categories
Check out the Formula Handbook template!