Count Cells With Text In Google Sheets

Steps to count cells with text in Google Sheets

Option 1: Count all cells in the selected range (including non-empty and empty ones)

• Step 1: Select any cell where you want the result to appear.
• Step 2: Type =COUNTA( then select the range of cells you want to count, close the parentheses, and press Enter.
  (Example: =COUNTA(A1:A10))

Result: The total number of non-empty cells in your selected range will be displayed, including cells with numbers, text, or any other content.

Option 2: Count only non-empty cells (ignore blank ones)

• Step 1: Select any cell where you want the result to appear.
• Step 2: Type =COUNTIF( then select the range, type a comma, followed by "*" inside double quotation marks, and close the parentheses.
  (Example: =COUNTIF(A1:A10,"*"))

Result: This returns the count of cells that contain any value, excluding those that are completely blank.

Tip: If some cells contain only spaces, they may still be counted—use TRIM in your data to clean them up first.

Option 3: Count cells that contain a specific value

• Step 1: Select the cell where you want the result to appear.
• Step 2: Type =COUNTIF( then select the range, type a comma, followed by the specific value you want to count in double quotation marks, and close the parentheses.
  (Example: =COUNTIF(A1:A10,"Apple"))

Result: The number of cells containing the exact value you specify will be shown, helping you quickly identify the frequency of specific entries.