Count if - Text
Hi,
Can you please help me to figure out why this formula is returing 0 while the range contains this text? =COUNTIF([Data]:[Data], "*Risk01*") The range is a drop down column allowing selection of multiple risk. I'm looking to obtain a number how many times each risk was selected. Risk01 is not the full text, only part of a sentence.
thank you
Answers
-
It's not working because you need the full text in the parenthesis. If you are trying to use a shortcut by looking for a part of text, you can do =COUNTIF(Data:Data, CONTAINS("Risk01", @cell))
-
thank you Eric, unfortunatelly it's still not working. I'm unable to put the full text as in some instances we can have multiple risks mapped while I'm interest in number of incidents mapped to each risk. I'm using a help column with =IF(CONTAINS("Risk01", [Data]@row), 1, 0) but it's polutting my sheet (we have over 50 risks). This information is feeding to a sheet summarry that feeds to a dashboard and I feel like I'm complicating things unnecessary
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!