count if / v lookup formula
I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statement at first but ran into an issue when two issues were reported for one proposal in a cell. I thought a work around would be to use a count if / v lookup formula to count the number of times a specific string appears. Looking at the reference sheet you can see it appears twice, along with the other issues in the cell.
Am I on the right track? This is what I have started but am stuck... Thank you in advance for help.
Best Answer
-
@Ashlynn, how did you format your COUNTIF? Did you just set it = "- Origin..."? Have you tried adding a CONTAIN instead? That way it doesn't matter how many items are in the cell, as long as it contains that string.
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K 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!