WORD_COUNT. It counts the number of words in cells.

 

WORD_COUNT. It counts the number of words in cells.

=LAMBDA(text,[total_only],

 LET(calc, MAP(text,LAMBDA(c,SUM(--NOT(ISERROR(TEXTSPLIT(c,

" ",CHAR(10),TRUE)))))), result,IF(total_only,SUM(calc),calc), 

 result))