Count if text in cell contains specific item
I'm trying to count how many times a specific text string appears in a cell but tie it to an event name that appears multiple times. I've tried countifs with a contain. I tried reversing it and starting with an IF(Contains) and can't get anything to return what I need. In plain English, count If Trip Name = 24-03 AND Type contains B. I'm doing the function in another sheet so its a reference to this sheet. I run into errors with every formula I've come up with. Thanks
Answers
-
Hi @jmhudso3,
Here is the formula I suggest:
=COUNTIFS({Trip Name Range}, "24-03", {Type Range}, CONTAINS("B", @cell))
For the snapshot provided, the count is 7. You can adjust the trip name and type with the text in quotes to run this formula for your different criteria.
Hope that helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!