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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!