How to Count Cells with Text in Google Sheets

To count cells with text in Google Sheets, you can use the COUNTIF function. The COUNTIF function is designed to count cells based on specific criteria. In this case, you want to count cells that contain text.

Here's a step-by-step guide on how to count cells with text in Google Sheets:

  1. Open your Google Sheet.
  2. Click on an empty cell where you want the result to be displayed.
  3. Type the following formula: =COUNTIF(range, "<>"). Replace "range" with the range of cells you want to count the text cells in. For example, if you want to count text cells in the range A1:A10, the formula would be =COUNTIF(A1:A10, "<>").
  4. Press Enter to get the result.


Let's say you have the following data in cells A1:A5:


You want to count the cells with text, so you'll use the COUNTIF function. In an empty cell, type the following formula:

=COUNTIF(A1:A5, "<>")

Press Enter, and you will get the result "3" because there are three cells (A1, A3, and A5) that contain text.

Did you find this useful?