Counting text from form submissions

RyanFoltz

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

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