| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 TeachExcel | 2009-02-03 00:17:49 |  338,595 Views |
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt
Excel Tutorials: https://www.teachexcel.com/src=yt
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.
To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.
Have a great day!
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
