Formula to tell me how many times a word shows up, but only for a specific Review Board

Here is what I need:

Count how many times Strongly Agree shows up, but only when the Review Board is General Medicine TAG.

I have this to give me the # of times Strongly Agree shows, how do I ensure I only get this for "General Medicine TAG": =COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"))

Find more posts tagged with

Formulas

Accepted answers

James Keuning

The dirty way to do it is to add an IF:

IF([Review Board]@row="General Medicine TAG",COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree")),"")

Or you can use COUNTIFS and add [Review Board]@row, "General Medicine TAG" to your formula.

Genevieve P.

Hi @Leann Gibson

It sounds like you only want to Count the "Strongly Agree" in the other sheet if the other sheet has "Oncology Tag" (or a different tag), is that correct?

If so, you'll need to add in another criteria into your COUNTIF statement, making it COUNTIFS plural. I would even suggest you could take out the first IF and simply use the cell in [Review Board] as your value to search for:

=COUNTIFS({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"), {Column with Review Board in other sheet}, [Review Board]@row)

See: COUNTIFS Function

Cheers,

Genevieve

All comments

James Keuning

The dirty way to do it is to add an IF:

IF([Review Board]@row="General Medicine TAG",COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree")),"")

Or you can use COUNTIFS and add [Review Board]@row, "General Medicine TAG" to your formula.

Leann Gibson

@James Keuning It was working until I tried to use it for the other three groups. Am I doing something wrong? This one should come up "0" for all and it is pulling the numbers from the original one I did.

Genevieve P.

Hi @Leann Gibson

It sounds like you only want to Count the "Strongly Agree" in the other sheet if the other sheet has "Oncology Tag" (or a different tag), is that correct?

=COUNTIFS({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"), {Column with Review Board in other sheet}, [Review Board]@row)

See: COUNTIFS Function

Cheers,

Genevieve

Leann Gibson

@Genevieve P. That worked - THANK YOU

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.