I need help with a count formula

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

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.