count if / v lookup formula

Ashlynn

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.

Eric Law

@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.

Eric Law

@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.

Ashlynn

Thank you @Eric Law, that worked!