![how to get word count in word how to get word count in word](https://i.ytimg.com/vi/oU4NyyJXwBg/maxresdefault.jpg)
![how to get word count in word how to get word count in word](https://media.idownloadblog.com/wp-content/uploads/2018/10/Pages-Word-Count-on-iPad-5th.jpg)
While it is unfortunate that your content can’t be automatically counted, as it can within Google Docs, it is not too hard to use the formula tool within Google Sheets to quickly and easily add content to your document and add up a certain word count. The formula for column counts ignores blank cells (without counting them as 1) and counts the words in each column cell to deliver a total word count for the column range specified. Yes, it is a more complex formula, but the method of using it is just as simple as you might expect from Google Sheets. Don’t click on another cell to save it or it may change your cell range. Edit the formula in the text box to reflect the correct cell range, then press enter to save it.Right-click the text box at the top that shows the cell’s contents, and then choose “Paste as plain text.” This ensures that the correct font and characters get pasted.Select the cell where you want the column word count to display.Start with the equals sign and ignore the period in the end when copying. Copy the formula shown above: =ARRAYFORMULA(SUM(COUNTA(SPLIT(A2:A11,” “)))-COUNTBLANK(A2:A11)).You could use the cell method to count each specific cell to receive a total word count, but as you can imagine for larger documents, this will take longer than you might want. Formula 1 above counts each empty cell as 1 word. In formula 2 above, using the “IF” command determines if there are empty cells, and if so, it does not count the cells as 1 word. Highlight the blank cell where you want to display your results and paste the following formula: =IF(A2=””,””,COUNTA(SPLIT(A2,” “))) where “ A2” specifies the cell to be counted.To preview word counts per cell with some cells being empty within your specified range, use the following instructions. Option #2: Word Count per Cell with Empty Cells in Specified Range A2 translates to Column, Row Number where “ A” is the column and “ 2” is the row number, which totals the word count in the specified cell.SPLIT counts everything separated by a space as an individual point of data (your content can be counted as a word, even if it’s just a number).COUNTA auto-counts the words in the cell.Here is the breakdown of the formula used, which was “ =COUNTA(SPLIT(A3, ” “)).” Click in your display cell or hit Enter to apply the formula.Īs you can see above, cell A3 has two words.The formula we used above helps us know the number of times the word February is present in cell A2. Step 2: Click Enter to see the word count in cell A14. Highlight the blank cell where you want to display your results and paste the following formula: =COUNTA(SPLIT(A3, ” “) ) where “ A3” specifies the cell. Step 1: Select the cell and enter the formula (LEN (cell)-LEN (SUBSTITUTE (cell,word,)))/LEN (word) as shown in the following image.