I need help with a count formula

Kris Miller

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

Paul Newcome

Try this...

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

Paul Newcome

Try this...

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

Kris Miller

Hi Paul,

Thank you for this - it isn't working though. I copied and pasted with SUCCESS :)

Thank you so much!

Kris

Paul Newcome

It isn't working or Success?

Kris Miller

Apologies Paul - it is working like a dream - thank you!

Paul Newcome

Great. Happy to help. 👍️