+5 votes
65 views
How to count cells with text in Google Sheets

in Guides by (552k points)
reopened | 65 views

1 Answer

+3 votes
Best answer

Count cells with text in Google Sheets
Count cells that have a specific text
Count the ones with text anywhere

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.

image

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.

image

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.

image

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.



by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Dec 31, 2021 in Guides by backtothefuture (552k points) | 106 views
+5 votes
1 answer
asked Oct 28, 2019 in Internet by backtothefuture (552k points) | 218 views
+4 votes
1 answer
asked Apr 21, 2023 in Guides by backtothefuture (552k points) | 67 views
+4 votes
1 answer
asked Nov 22, 2022 in Guides by backtothefuture (552k points) | 67 views
+5 votes
1 answer
asked Jan 9, 2022 in Guides by backtothefuture (552k points) | 102 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users