Not able to get Countif to work with Contains

Gopikrishna Mamidipudi

I have sheet that has a column called Legal Tasks. I'm trying to write a Countif formula that counts the number of times the word in Column2 appears in the Legal Task column.

As the formula stands it is trying to do an exact match, however my intent is to include in my count everytime the word appears by itself or with the some others.

In the screenshot the {Employee-LegalTask} range is the entire Legal Task Column.

Any help appreciated.

Mike Wilday

Try this formula. I got it to work within a sheet. It should work with cross sheet references as well. 

=COUNTIF({cross sheet reference}, FIND("One", @cell) > 0)

Mike Wilday

*Note: You might have to recreate that cross sheet reference.

Gopikrishna Mamidipudi

Could not get it to work.

 

I'm using this:

=COUNTIF({Employment-LegalTask}, FIND(Column2@row, {Employment-LegalTask}) > 0)

 

Mike Wilday

Try this: =COUNTIF({Employment-LegalTask}, FIND(Column2@row, @cell > 0)

Gopikrishna Mamidipudi

I'm getting the INVALID DATA TYPE error. See the attached images.

Gopikrishna Mamidipudi

Please see me comment below.