Not getting total text count in Numbers app

Hi Ryszard,

Here is one way, using the SEARCH function in another column. You can hide that column when all is working.

SEARCH finds the starting position of one string of text within another string of text.

Formula in B2 is SEARCH(A$1,A2)

SEARCH chucks a hissy fit (red error triangle) if it can't find what you told it to find. However, the COUNTIF formula in the Footer cell A13 works (much to my surprise):

Formula in Footer A13 is COUNTIF(B,">0")

Hint: I used SEARCH (ignores upper/lower case) instead of FIND (case sensitive).

Regards,

Ian.

Here are a few examples of other ways to count the items in column A:

If you are trying to get the count of cells that have "product" anywhere in them,

=COUNTIF(A,REGEX("product",0))

If you want the count of all cells that have anything in them (i.e., blank cells) including formulas that result in the null string "",

=COUNTA(A)

If you want the count of cells that start with "product",

=COUNTIF(A,REGEX("^product",0))

If you want the count of cells that start with "product" followed by a space and then at least one digit:

=COUNTIF(A,REGEX("^product \d",0))

And if you want a "word count" of all whatever is in all the cells in column A

=COUNTMATCHES(TEXTJOIN(" ",TRUE,A),REGEX("\w+",0))