✦Template Printable Ideas Insights

"How to Count Word Count in Google Sheets"

By

Counting the word count in Google Sheets can be a convenient and efficient way to analyze text data. Unfortunately, Google Sheets doesn't have a built-in function to count words, but we can use a combination of functions to achieve this. Let's explore two methods: using cell counting and using LEN and SUBSTITUTE functions.

Before we proceed, ensure your data is in a single cell for the first method or divided into separate cells for the second method. Also, make sure there are no leading, trailing, or excess spaces in your text to avoid inaccurate counts.

Method 1: Cell Counting

The first method involves using the COUNTA function to count the number of non-empty cells in a range, which effectively counts the number of words. This method assumes that words are separated by spaces and that each cell contains one word.

How to Count Words in Google Sheets
How to Count Words in Google Sheets
Monthly Word Count Tracker | Novel Planner | NaNoWriMo Tracker | Book Writing Planner | Write a Book | Word Count Tracking | Google Sheets
Monthly Word Count Tracker | Novel Planner | NaNoWriMo Tracker | Book Writing Planner | Write a Book | Word Count Tracking | Google Sheets
How to Check the Word Count in Google Sheets - Make Tech Easier
How to Check the Word Count in Google Sheets - Make Tech Easier

Here's how you can use it:

Step 1: Wrap Text

First, you need to wrap your text in each cell so that pressing Enter takes you to the next line rather than creating a new cell. To do this, select your cells, right-click, and choose "Format cells" (or press Ctrl + 1). Under the "Number" tab, click on "More formats," select "Wrapped," and click "OK".

How to count total words in an spreadsheet.
How to count total words in an spreadsheet.
How to See Word Count in Google Docs As You’re Writing
How to See Word Count in Google Docs As You’re Writing
How To Get Word Count in Google Sheets
How To Get Word Count in Google Sheets

Step 2: Use the COUNTA Function

Now, in a new cell, enter the formula `=COUNTA(YourRange)`, replacing `YourRange` with the range containing your text. For example, if your text is in cells A1 to A10, your formula would be `=COUNTA(A1:A10)`. Press Enter, and the function will count the number of non-empty cells in the range, giving you the word count.

Method 2: Using LEN and SUBSTITUTE Functions

The second method uses the LEN function to count the number of characters and then subtracts the number of non-letter characters (spaces, punctuation, etc.) using the SUBSTITUTE function. This method allows for words containing punctuation at the end (like "word," or "word!").

Here's how you can use it:

Smart Word Count Tracker for Writers on Google Sheets | Excel File Download | Author Planner Digital Templates | Nanowrimo Wordcount tool
Smart Word Count Tracker for Writers on Google Sheets | Excel File Download | Author Planner Digital Templates | Nanowrimo Wordcount tool
Novel Writing Word Count Tracker, Google Sheets Template (Instant Download)
Novel Writing Word Count Tracker, Google Sheets Template (Instant Download)
COUNT vs COUNTA vs COUNTBLANK vs COUNTIF - Explained Clearly
COUNT vs COUNTA vs COUNTBLANK vs COUNTIF - Explained Clearly
How To See Word Count On Google Slide - TFOT
How To See Word Count On Google Slide - TFOT
Google Sheets Tips COUNTIFS Function, Infographic
Google Sheets Tips COUNTIFS Function, Infographic
Word Count Tracker, Monthly Yearly Author Wordcount Google Sheets Template, Writers Spreadsheet NaNoWriMo Tracker, Spreadsheet 2026
Word Count Tracker, Monthly Yearly Author Wordcount Google Sheets Template, Writers Spreadsheet NaNoWriMo Tracker, Spreadsheet 2026

Step 1: Calculate the Total Number of Characters

In a new cell, enter the formula `=LEN(YourCell)`, replacing `YourCell` with the cell containing your text. For example, if your text is in cell A1, your formula would be `=LEN(A1)`. This will give you the total number of characters in your text.

Step 2: Subtract the Number of Non-Letter Characters

In the same cell, adjust the formula to subtract the number of non-letter characters: `=(LEN(YourCell)-LEN(SUBSTITUTE(YourCell," ","")))/3`. This formula subtracts the number of spaces and then divides by 3, since each word contains an average of 3 characters (including spaces). For example, if your text is in cell A1, your final formula would be: `=(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))/3`.

Either method should give you the word count in your Google Sheets document. You can now use this information for further analysis or to meet your specific requirements. Happy counting!

How to Use COUNTA on Google Sheets, Infographic
How to Use COUNTA on Google Sheets, Infographic
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros