How to Count Cells Containing Text in Google Sheets

To count cells containing text in Google Sheets, we will use two functions: COUNTA and COUNTIF. With these two functions, users can count cells containing text within a specified range of data or simply within a single row. Additionally, users can count non-empty cells with a specific character they want to find. The following article will guide you on how to count non-empty cells in Google Sheets.

1. Counting Cells Containing Text in Google Sheets

If you are looking to count the number of cells containing any text or numbers, use this method. This approach will count the total number of non-empty cells within the specified data range.

Step 1:

Open the data sheet in Google Sheets. In the cell where you want to display the result of the count, we will use the COUNTA function and select the data range that you want to count cells containing text.

Enter the formula =COUNTA(B21:B30) and press Enter to execute the function.

Step 2:

Immediately after, you will see the count of cells containing text as shown below.

2. Counting Cells Containing Text in Google Docs Specifically

If you want to find the number of cells containing a specific text or number, you need to use the CountIf function. With this function, you can specify the text or number, and the function will count the cells that contain that specific text or number.

Enter the formula =COUNTIF(B2:B11, “Apple”) and press Enter.

3. Counting Cells Containing Text in Google Sheets with Additional Characters

If you want to count cells containing specific text along with other characters or content, you can still use the CountIf function, but the formula will be different. This counting method will count cells that contain the specified text, regardless of any accompanying content.

In the cell where you want to display the result, enter the formula =COUNTIF(B2:B11, “Apple“) and press Enter.

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top