Using COUNTIF Formula

Nina R

Hello,

I am trying to calculate the number of times a certain type of request come through on a form in instances where multiple options can appear in the one cell. I've tried manipulating the formula several ways, but it still is not calculating correctly. Can you help me figure out what I'm doing wrong? The 2 formulas that seem to get me closest to what I'm attempting are:

=COUNTIF({TEST Talent Intelligence Request Form Range 2}, CONTAINS("Market Summary", [Primary Column]@row)) - I'm doing this calc on another sheet

OR

=COUNTIF([What elements would you like included?]:[What elements would you like included?], "Market Summary") - I'm doing this calc on the sheet summary page

Neither of these options is calculating correctly. What am I doing wrong? The data lives in the second screenshot and the end user has the ability to select one or more of 4 options on the form, so I want to be able to count the instances for when each of the 4 options are selected and submitted with the form.

Paul Newcome

Try this:

=COUNTIFS({TEST Talent Intelligence Request Form Range 2}, HAS(@cell, [Primary Column]@row))

Paul Newcome

Try this:

=COUNTIFS({TEST Talent Intelligence Request Form Range 2}, HAS(@cell, [Primary Column]@row))

Nina R

That worked, thank you!

Paul Newcome

Happy to help. 👍️