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"))
Best Answers
-
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. -
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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. -
@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.
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. That worked - THANK YOU
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!