Counting words on Glide table!

Ask for Help
1

Hello Gliders, I believe it is possible to count words on google sheet using COUNTA function along with SPLIT " " etc if I am not mistaken. I tried COUNTA function on google sheet but it only counted the single cell. As you can see in this example below, 264 words found in H2 which counted the entire words in G2. I tried Arrayformula but didn’t work and really hard to keep dragging the formula to keep it running. If there is any way around to achieve it?
image

Would it be possible to achieve it on Glide instead as it will keep counting words instantaneously which is really cool!

image
image897×623 33 KB

Thank you in advance for any helpful tips anyone of you might have.

2

Working example is ready. What this does is to replace all “text” characters by an empty one so what is left are all “spaces”.

Let’s say you have a sentence like “A B C” then the regexreplace will leave the 2 spaces. Hence we have to add 1 to that to get the total number of words.

image
image722×377 13.7 KB

4 Likes
3

It worked perfectly with a little increase which I am trying to understand. I admit that I am a beginner on Google sheet trying to understand it.

Mine is on Column H which is based on SPACE using COUNTA(SPLIT(G2," "). Yours is somehow magic but what is it based on? Space?

image

4

I suspect that’s because of the “next line” characters. Will try to find a way out of it.

5

image
image1107×388 17.4 KB

@DareSteps it should be ok to test again now.

6

Yours is the highlighted one (Column J) and it indeed minimized the difference. Compared to mine (Column G), there is a little difference. I guess mine is wrong because it splits up words based on space. Yours splits up words based on? length of words? or space? or…

7

It does the things below:

  • Brings all words into “one line” (clear all the new lines characters and brings words onto the same line).

  • Replace all “text” characters as empty, which leaves the space characters only.

  • Calculate the number of space characters and add 1 to get the final result.

2 Likes
8

So clear. Thank you so much.

2 Likes