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!!!

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @RyanFoltz

    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