How to count elements that contains part of the string

Mixer

Hi,

I'm trying to countif elements in the column that starts with a string "apple".

E.g: I have 30 rows with strings like: "red apple" "yello apple" "green apple".

I uses formula Countif(childern(fruits),CONTAINS("apple",children(fruits))) but it doeas not work.

Thanks for help!

Paul Newcome

Try something like this...

=COUNTIFS(CHILDREN(Fruits@row), CONTAINS("apple", @cell))

Paul Newcome

Try something like this...

=COUNTIFS(CHILDREN(Fruits@row), CONTAINS("apple", @cell))

Mixer

Thank you!

=COUNTIFS(CHILDREN(Fruits), CONTAINS("apple", @cell)) <- This one worked

Paul Newcome

Happy to help! 👍️