I'm trying to count the number of items in a column where part of the text shows. Is there a way to do this?
For e.g., I'd like it to count up the number of rows from a column in which the words "ids" show up. Keeping in mind this only part of the text (e.g. some rows say "ids?", "ids due", "IDS? Client refs" etc."
I've tried =COUNTIF(ActionDue1:ActionDue184, "*ids*") but it comes up as 0 because it's looking for the exact word and not part of it.
Thanks in advance!