Table of Contents
Counting cells with text in Google Sheets can be done using the COUNTIF function. This function allows users to specify a certain criteria, in this case, text, and count the number of cells that meet that criteria. To do this, first select the range of cells you want to count, then use the COUNTIF function with the criteria set to “text”. This will give you the total number of cells containing text in the selected range. Additionally, you can also use the COUNTA function to count all non-empty cells, including those with text. These functions can be useful for analyzing data and keeping track of information in a Google Sheets document.
Count Cells with Text in Google Sheets (3 Examples)
You can use the following methods to count cells with a particular text in Google Sheets:
Method 1: Count Cells with Any Text
=COUNTA(A1:A10)Method 2: Count Cells with Specific Text
=COUNTIF(A1:A10, "Text")
Method 3: Count Cells with One of Specific Texts
=ArrayFormula(SUM(COUNTIF(A:A,{"Text1","Text2"})))The following examples show how to use each method with the following dataset in Google Sheets:
Example 1: Count Cells with Any Text
We can use the following formula to count the number of cells with any text in column A:
=COUNTA(A2:A12)The following screenshot shows how to use this formula in practice:
We can see that there are 8 cells with any text in column A.
Example 2: Count Cells with Specific Text
We can use the following formula to count the number of cells with the text “A” in column A:
=COUNTIF(A2:A12, "A")The following screenshot shows how to use this formula in practice:
We can see that there are 2 rows with the text “A” in column A.
Example 3: Count Cells with One of Specific Texts
We can use the following formula to count the number of cells with the text “A” or “B” in column A:
=ArrayFormula(SUM(COUNTIF(A:A,{"A","B"})))The following screenshot shows how to use this formula in practice:
We can see that there are 5 rows with the text “A” or “B” in column A.
Additional Resources
Cite this article
stats writer (2024). How do I count cells with text in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-count-cells-with-text-in-google-sheets/
stats writer. "How do I count cells with text in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-count-cells-with-text-in-google-sheets/.
stats writer. "How do I count cells with text in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-count-cells-with-text-in-google-sheets/.
stats writer (2024) 'How do I count cells with text in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-count-cells-with-text-in-google-sheets/.
[1] stats writer, "How do I count cells with text in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do I count cells with text in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.