Google Sheets Count Cells with Text

Google Sheets: Count Cells With Text (Any Text, Text Only, Specific Text, and Blanks) This episode shows how to count cells with text in Google Sheets depending on what you need: counting any non-empty status values with COUNTA over the range D2:D, counting only cells that contain text (excluding numbers) with COUNTIF using the wildcard criterion "*", counting a specific status like "Shipped" with COUNTIF and a text criterion, and avoiding retyping criteria by referencing a cell that contains the status text. It also demonstrates counting empty cells with COUNTBLANK over D2:D, using an example status column that includes both text statuses and numeric entries. 00:00 Count Cells With Text 00:29 Count Any Nonblank 00:45 Count Text Only 01:18 Count Specific Status 01:35 Use Cell References 02:14 Count Blank Cells 02:29 Wrap Up And Subscribe