In Google Sheets it is possible to count all the cells that have text or numbers, we can do it by specifying that these cells have only that text or all those that contain it; regardless of whether they are accompanied by numbers or other words..
Google Sheets is a powerful and free tool that allows us to work with spreadsheets in much the same way as we would in Microsoft Excel. It has different functions such as checking spelling and counting characters, which can be very useful together with the function that we will talk about next.
Count cells with text in Google Sheets
To get the number of cells that have text or even numbers, we're going to need to use the COUNTA function in our spreadsheet like this..
We start by opening the spreadsheet in question and we are going to click on the cell in which we want to see the result.
Next, we will need to write the following function: =COUNTA(C2:C11)
Obviously, we are going to have to substitute “C2” and “C11” for the cells of our spreadsheet..
In this simple way, in the selected cell we will see the number of cells that have numbers or text.
Count cells that have a specific text
In this case we will have to use the COUNTIF function to achieve it. We open our document and click on the cell where we want to see the result.
In the selected cell we will have to add the following function: =COUNTIF(C2:C11,"Example")
We will have to change “C2” and “C11” for the cells of our document and “Example” for the specific text that we want to post. In this simple way we will see the number of cells that contain that specific word.
Count the ones with text anywhere
To finish, we can do the same as the previous example, only this time we are going to count all the cells that have the specified text; regardless of whether it is accompanied by other text.
We select the cell where we want the result to appear. We are going to have to substitute “C2” and “C11” for the range of cells of our document and “Example” for the text we are looking for: =COUNTIF(C2:C11,”*Example*»)
Here we have assigned an asterisk before and after the text, so that the function is able to count what we specify no matter where it is.
As a result, we will see all the cells that contain the specified text.