Fix a Word Count of Zero #googlesheets
Learn how to fix the word count issue in Google Sheets where blank cells incorrectly count as one. This video demonstrates how to use the IF and ISBLANK functions to achieve accurate word counts.
In a previous video I showed you how to do word count, for any cell in Google Sheets. But, what's going to happen is it's going to be the number one if a cell is blank, which is wrong. This has zero words. We can fix this. Wrap the formula with if. ISBLANK(). We'll put the same cell, B2. We'll add a comma, and so if it's true, if it actually is blank, we don't want to do anything. So we actually want two commas here, and then if it's false, meaning the cell is not blank, we want to get the count. End parentheses, hit enter, and now if we copy paste this, it's now blank. Which is great.