Initially, Excel spreadsheets were designed to work with numbers. But these days we often use them to store and manipulate text too. Want to know how many cells with text there are in your worksheet? Microsoft Excel has several functions for this. Continue reading
Comments on: How to count cells with text in Excel: any, specific, filtered cells
by Svetlana Cheusheva, updated on
Comments page 2. Total comments: 57
Im looking for a formula to give me only the number of managers I have working projects. Each manager has multiple projects they work on. Manager names are in column A. Projects in B. I only want to know the total managers I have, not the projects I have. For instance, John's name is listed 8 times, Mike's name is listed 6 and Jill's name is listed 7 times. The answer I want is 3.
Hello!
I recommend that you study our guide to calculate how many unique values are in the list.
hello sir,
i have a 03 criterias (higher,lower and standard)in a column which ranges from (8-34200 rows)i also have date column now my problem is whenever i makes a filter in date for example if i want to check how many higher ,lower cases are occured on particular date
Hello!
If I understand your problem correctly, you need to use the COUNTIFS function to count. Read more here.
hi. Need help.
I have a row of numbers and text "IN" (in different cells).
What formula do I use to count the total if any of the cells in the row have numbers and IN.
Thank you in advance
Hello!
If I understand your task correctly, please try the SUM formula. It ignores text and only sums numbers. You can read more in this article.
Good Day Sir,
My question is this. I have a list of all "Fruits" in column A. Those "Fruits" count for many row entries each. I would like to count how many rows each "Fruit" totals to. Lets say I have "Apple" 50 times, "Banana" 20 Times and each "Fruit" has a different number of appearances and there are a LOT of different "Fruit". My goal is to create a list of how many times the "Fruit" shows on my spreadsheet in a certain Column and output a count by Type of "Fruit". So I get a list of How many times "Apple" shows or "Banana" Shows.
Hello J. Merry!
You can use the COUNTIF function, for example = COUNTIF (D2: D10, "Apple"). You can read more about this on our blog in more detail. However, I recommended using a pivot table. Read more about pivot tables here.