Counting text from form submissions

Hello,

I am trying to count the number of times a word is selected from a drop-down menu by quarter

Here is my formula. I keep getting #unparsible

=COUNTIFS(FIND("topic",{2022 Tracker Range 1}>0, {2022 Tracker Range 1}, "Q1"}

I have even tried with contains, and I have the same issue.

Please help!!!

Find more posts tagged with

Accepted answers

All comments

The syntax of COUNTIFS is COUNTIFS(range1, criteria1, range2, critera2, etc). I fixed the CountIfs syntax and added the @cell to the CONTAINS.

=COUNTIFS({2022 Tracker Range 1},CONTAINS("topic", @cell), {2022 Tracker Range 1}, "Q1")

Kelly

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.