It’s almost the same formula where I have added the SUM formula and changed the range is the SPLIT part to include a range instead of a single cell.Īnd since I am playing with a range of cells, you need to use ARRAYFORMULA to make sure it gives the right result. = ARRAYFORMULA ( SUM ( COUNTA ( SPLIT ( A2:A4, " " ) ) ) ) You can also extend the above formula to give you the word count of all the text in an entire column. Note that this formula works even if you have any leading, trailing, of double spaces in between the words. If you don’t use the IF function, the formula will return 1 even when the cell is empty. The COUNTA function then simply counts the total number of these delimited values.Īnd the reason I have used the IF formula is to make sure I get a blank when there is no text in the cell. In this formula, my delimiter is a space character, so the SPLIT function would give me an array of text string delimited by the space character. The above formula uses the SPLIT function, which separates the text string based on the delimiter. The following formula will give you the word count: = IF ( A2 = "", "", COUNTA ( SPLIT ( A2, " " ) ) ) Suppose you have a dataset as shown below and you want to get the word count in each.
Labels: how to subtract footnotes from word count, Word and Pages, word count in iWork Pages.Īlexander Anichkin am.
Post navigationĬlick on the image to enlarge it. The Inspector on the left shows word count for this post. Please let me know if you have developed a special technique or are struggling to find a way of doing a particular task.
Word count is an important professional tool which has many uses. The article has become and still remains one of the top read on this blog, even though in Pages'09 the word count is displayed at the bottom of an open document. Many users complained it was difficult to find and awkward to use. Maybe you noticed that Word for the web gives you an approximate word count. Then on the Tools menu, click Word Count. To count the number of words in only part of your document, select the text you want to count. Unless you have selected some text, Word counts all text in the document, as well as the characters, and displays them in the Word Count box as the Statistics. You can view the number of characters, lines, paragraphs, and other information in your Word for Mac, by clicking the word count in the status bar to open the Word Count box. The status bar shows the word count for that selection and for the entire document.
You can also count the number of words in only part of your document. Right-click on the status bar at the bottom of the document. If you do not see the word count in the status bar.