Countifs with Contains function
Hello,
I am having trouble with this formula. Basically we have a list of employees with a column for their position, and their schedule. If they are in training, the schedule starts with "Effective" followed by the date they leave training. I am trying to pull the number of people in each position that are in training by locating the partial text. Below are two formulas I'm trying out but neither are working, any suggestions?
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2},"Effective")
=COUNTIFS({Team Sheet Range 1}, Position@row, CONTAINS("Effective", {Team Sheet Range 2}))
Best Answer
-
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2}, CONTAINS("Effective", @cell))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2}, CONTAINS("Effective", @cell))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!