# How to count words on Google Sheets

There are several ways we can count word count on Google Sheets. Let’s find out how to count words on this Google Sheets through the article below.

When using Google Sheets, we realize that the data in Google Sheets is mostly numbers but in addition to the numbers, Google Sheets documents still need words and words to represent its contents. You may know how to use Google Sheets to calculate but when you want to know how many words are in the text, see if it fits your initial conditions, then you Again unknown ?.

There are 2 ways you can count words on Google Sheets. The first way is to count on each cell, the second way is to count on the entire column. Today, Taimienphi.vn will work with you to learn about 2 How to count words on Google Sheets hey. Please refer.

COUNT WORDS IN GOOGLE SHEETS BOXES.

We will first count the number of words on the cells. In the example below, we will count the number of words in cell A10.

Step 1: Open the Google Sheets you want to count words from

Step 2: Select a cell you want to display the counting result

Step 3: Enter the formula ‘= COUNTA (SPLIT (A10,” “))’ in the selected cell or in the calculator bar fx.

Step 4: You press Enter to complete the recipe.

You will see the result is 3 corresponding to the number of words in A10.

COUNT FROM THE ENTIRE ONE OF GOOGLE SHEETS

Now we will see how many words in a column the night. In the example below, we will count the number of words in column A.

Step 1: Open the Google Sheets you want to count words from

Step 2: Determine which cells in the column you want to display the counting result

Step 3: Enter the formula = ArrayFormula (LEN (CONCATENATE (A7: A10 & CHAR (47))) – LEN (SUBSTITUTE (CONCATENATE (A7: A10 & CHAR (47)), “/”, “”))) in the selected cell or in the calculator bar fx.

Step 4: Click Enter to complete the recipe.