I need help with a count formula

Options

Hi All,

I need help with a Count formula.

I columns that have a 3 option dropdown and I want to report on the number for each using a formula (Countif /s or any other formula).

I am happy to setup 3 separate formulas for each of the 3 options, so don't need anything fancy. Just need help creating a formula that counts the number of each type of options separately.

This is what I currently have tried:

=COUNTIF([Biodiversity Exemption Status]1:[Biodiversity Exemption Status]82, CONTAINS("1 - Full Exemption in place")")

=COUNTIFS([Biodiversity Exemption Status]1:[Biodiversity Exemption Status]82, CONTAINS("1 - Full Exemption in place")")

=COUNTIF([Biodiversity Exemption Status]1:[Biodiversity Exemption Status]82, FIND("1 - Full Exemption in place")")


None of these work. Can anyone assist me?

Thanks

Kris

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!