Table of Contents
To count the number of rows with text in Excel, follow these steps:
1. Select the entire range of cells in the column where you want to count the rows.
2. Go to the Home” tab and click on the “Find & Select” button.
3. From the drop-down menu, select “Go To Special”.
4. In the pop-up window, select “Constants” and then check the box next to “Text” under the “Data” section.
5. Click “OK” and all the cells containing text will be selected.
6. Look at the bottom right corner of the Excel window, where you will see the total number of selected cells. This will be the number of rows with text in the selected column.
This method can also be used to count the number of rows with specific types of text, such as numbers, dates, or formulas. It is a quick and efficient way to get an accurate count of rows with text in Excel.
Count Rows with Text in Excel (3 Examples)
You can use the following methods to count rows with particular text in Excel:
Method 1: Count Rows with Any Text
=COUNTIF(A2:A11, "<>")Method 2: Count Rows with No Text
=COUNTBLANK(A2:A11)Method 3: Count Rows with Specific Text
=COUNTIF(A2:A11, "Mavs")The following examples show how to use each method with the following dataset in Excel:
Example 1: Count Rows with Any Text
We can use the following formula to count the number of rows with any text in column A:
=COUNTIF(A2:A11, "<>")The following screenshot shows how to use this formula in practice:
We can see that there are 8 rows with any text in the Team column.
Example 2: Count Rows with No Text
We can use the following formula to count the number of rows with no text in column A:
=COUNTBLANK(B2:B11)The following screenshot shows how to use this formula in practice:
We can see that there are 2 rows with no text in the Team column.
Example 3: Count Rows with Specific Text
We can use the following formula to count the number of rows with a value of “Mavs” in column A:
=COUNTIF(A2:A11, "Mavs")The following screenshot shows how to use this formula in practice:
We can see that there are 3 rows with a value of “Mavs” in the Team column.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I count the number of rows with text in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-rows-with-text-in-excel/
stats writer. "How can I count the number of rows with text in Excel?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-rows-with-text-in-excel/.
stats writer. "How can I count the number of rows with text in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-rows-with-text-in-excel/.
stats writer (2024) 'How can I count the number of rows with text in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-count-the-number-of-rows-with-text-in-excel/.
[1] stats writer, "How can I count the number of rows with text in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I count the number of rows with text in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.