How to Count Cells Containing Text in Google Sheets in a Few Simple Steps

To count cells containing text in Google Sheets, you will use 2 functions in Google Sheets: COUNTA and COUNTIF. With these 2 functions, users can count cells containing text in a certain data range, or more simply, in 1 row.

To know how to count cells containing text in Google Sheets on your computer, please refer to the simple steps below.

Step 1: First, go to Google Sheets. Open the available data table.

Step 2: You will use the "COUNTA" function. Now, you select an empty cell and enter the COUNTA function. Then, you select the data area to count text and press Enter.

Step 3: If you need to find a cell with a specific name, you will use the COUNTIF function and the method will be the same as the above step but you will type in the specific name you want to find. You will get the result as shown in the illustration below.

The above article has shared with you how to count cells containing text in Google Sheets. Hopefully, the above information can help you filter data and find the number of cells containing your data more easily.

Source: https://baoquocte.vn/cach-dem-o-chua-van-ban-trong-google-sheets-voi-vai-buoc-don-gian-259449.html