Can't COUNTIF if NO MATCH?
So strange - the formula appears to be right, but something isn't working...
The formula looks across 18 columns to see if there are any that have the text "SrLead3" - an identifier for a job title. That identifier is in that row, but if #NO MATCH appears in any of the cells it is looking in for the COUNTIF formula, then I don't get the count result - I also get #NO MATCH. But the text is there, so I'm not sure what's happening.
=IF(ISBLANK([#1 Activity Description]@row), "", COUNTIF([Contact 1]@row:[Job Title 14]@row, CONTAINS("SrLead3", @cell)))
The cell with the formula:
The cells it is looking in:
You can clearly see that in the cells it is searching in, it should find SrLead (its in the Job Title 4 column). Instead, it returns #NO MATCH:
Help Article Resources
Check out the Formula Handbook template!