Dear Community,
Is there a way to do COUNTIF in Numbers for partial text match? I have a very long column of text in Numbers and I want to count the number of cells that contain a partial matches to a given text.
Thanks,
Rob
Hi Rob,
Try this. I copied and pasted your question into a Numbers table. Then I used the SEARCH function to locate the first occurrence in each cell of a string ("co") entered in Header Row A1.
If SEARCH does not find the string, IFERROR steps in to return the NULL character ("").
Formula in Footer Row B9:
=COUNTIF(B,">0")
Three cells contain at least one occurrence of the string "co".
Regards,
Ian.
Here's a simple example, where the partial text" is a single letter.
The formula is entered in B2 and filled right to D2
The * is a wild card character.
The ampersands join the contents of B1 to the text (enclosed by quotationmarks) on either side into a single text string.
Regards,
Barry
Thank you Berry, this worked perfectly.
Thanks. I appreciate it.
COUNTIF partial text match
