Need Formula Help: How to count multiple drop down values?

edited 03/11/24 in Formulas and Functions

Problem Statement:

I have a sheet that was used in a form with multiple drop down selections and need to discover how to calculate total selected by category.

Need to count how many times apples was selected.

Example of column sheet:

Column Choices: apples, grapes, oranges, other

I have tried using the COUNTM formula and I keep getting an error. Here is the current formula being used:

=countm(reference other sheet), [apples])

What is wrong with my formula and how can I adjust to make it work? Thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!