Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Count Cells That Only Contain Text in Microsoft Excel

This Excel video tutorial shows you how to write a formula which will count the cells in a list which contain text. The problem is that, often times, you may have a list in Excel which contains text and numbers throughout; when this is the case, you can't count only the text cells without also counting the number cells. This may seem like a very straightforward thing to do, however, Microsoft Excel does not provide one function which can do just this. That means that we need to combine two separate count functions in order to count just the cells which contain text. The functions needed to do this are the COUNT() and COUNTA() functions in Excel.

This is a short yet useful tutorial which will help to save you some time when you need to count cells within a list which contain text within Excel.
   Topics Covered
Count Only the Text Cells within a List
Count Cells in a List in Excel
   Difficulty:         Easy
   Video:               Yes

Got a Question? Ask it Here in the Forum.