Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

In this lesson, I’m going to be showing you how to:

  1. Use the COUNT and COUNTIF function to ONLY count the number of cells, which contains TEXTUAL data
  2. Be able to use a combination of the COUNT function to be able to count ONLY TEXT from a list or range of cells.

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 9: Simple Subtraction Formula in Excel

Or go back to:

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

54 thoughts on “Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data”

  1. Hi Habib,

    I realised I have never used COUNTIF function. It does reduce the number of steps effectively. The excel spreadsheet is powerful if one learns the functions properly.

    Thanks for sharing! Your videos makes it easy to digest the materials.


    • Thanks Sam for your feedback. Yes, COUNTIF function is an amazing function in Excel. I hope my Excel tutorials are helping you learn new functions.

      Wishing you all the best

      Habib (ICT Tutor)

  2. Hi,

    I found this lesson very interesting. It was really well explained and broken down in way so it was easy to understand.

    I look forward to your tutorials, and enjoy how they are presented. Spent many years with Excel, so it’s always good to brush up on my skills.

    Great work!

    All the best

    • Hi Adam,

      I’m glad to hear you are still finding my lessons useful even if you are expert in Excel yourself. Thank you for your feedback on my style of teaching.

      Best wishes

      Habib (ICT Tutor)

  3. I’m following your lessons with great interest as I’ve never really understood many of the functions in Excel. I’ll definitely need to watch this video on count and count if functions several more times to fully understand. I’m also going to try it for myself as this always helps! Your teaching is very clear and easy to follow:)

    • Hi Kathy,

      Many thanks for your lovely feedback. It’s very much appreciated. 🙂

      Yes definitely! You can continue to watch more of my lessons on my YouTube channel.

      All the best
      Habib (ICT Tutor)

  4. Hi Habib,

    Thanks for this tutorial of “count,” “counta” and “countif” I love how convenient it is to calculate the cells’ information and mix-match them for a better data report. It’s good to learn only to count textual data from an excel sheet. Thanks a lot.


    • This is great to know Matt. I will be doing many more lessons on lots of others areas of the Microsoft programs. So watched out that those.

      Best Regards

      Habib (ICT Tutor)

  5. I have learned a lot in your lessons Habib and I’m grateful to have landed here. All these functions you have taught form Lesson one to 8 effortlessly made me understand excel way better than when I first learned excel. Your explanations were very simple and easy to comprehend. I hope Excel beginners will find your page.



  6. Hey Habib,

    I am going to share these articles with some of my colleagues, as they need to learn more about excel than I do. Especially these COUNTIF functions, as they would really help with our delay minute statistics in our engineering department at TfL.

    I will let you know how they get on with these functions and if they need any further help, then I will get in touch with you. Is that OK with you?

    Thank you for sharing and keep up the great work.

    All the best,


  7. Another excellent tutorial Habib. keep up the excellent work. No doubt with job losses increasing, people will need to start learning online/computer skills and you are the man to help!

    • Hi Russ,

      This was one of the reasons I turned to creating Video tutorials to help support those who need to level up their skills in the job search.

      Many thanks for the support.

      Habib (ICT Tutor)

  8. Hi Habib
    I recently started making concerted efforts to learn and relearn Excel functions as I would like to use VBA to test trading methods on historical stock data. In starting to think through the processes I will need to program to produce reports I see how COUNTA COUNT and COUNTIF functions could be useful. I am reminded how much easier it is to learn something when you have an actual practical problem to solve and what you learn can be applied to it. Thanks for a great lesson.
    Best regards

  9. That is really cool to know. I used countif all the time but never with the “*” as a wild card. I also never used counta using the “-” sign and count together like you did. Wow, these little tricks will go along way in trying to display the data the way I want to. Thanks so much for sharing this valuable information.

    • Hi Rick,

      I’m glad to hear you are learning new tips and tricks of Microsoft Excel through my tutorials. I want to spread the knowledge in the best and simple possible way.

      Many thanks for your feedback.

      Habib (ICT Tutor)

  10. Cool tutorial there. I must admit I’m pretty hopeless with using formulas in Excel. Thanks for the tips.

  11. Habib,

    Using the COUNT and COUNTIF functions in Excel to count only cells with text are very convenient functions to utilize. I appreciate you showing us different strategies to use (including the “hack” in today’s lesson) as I feel that enhances our learning experiences even more.

    Thank you for another great lesson.

  12. Thanks for another comprehensive tutorial. You really make my work so much easier. You seem to know everything about Excel. How many years of experience do you have and what methods did you use to learn?

  13. Hi Habib!
    This lesson Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data was very useful, I remembered a case where it would come in handy if I knew how to use it at the time.
    While watching and listening to the video, I opened the excel document and followed the instructions, and this magic of excel sometimes still impresses me very much. If you know how to use the functions, you can be a real wizard, and the work is made much easier and faster.
    Thanks for sharing your knowledge!
    Friendly greetings,

  14. Hi Habib,
    Thanks so much for all your free training on using Excel.
    I thought I had a good handle on using this, but I’ve been learning new ways to make my work easier.
    It’s amazing how many functions there are, lol.

    • You’re welcome Suzanne. Many people don’t realise what I am giving here. Others charge thousands of pounds for such series of lessons, but I’m giving it all for free, as I want everyone to be in education, especially in this crisis with the Covid 19.

      The functions are very large in numbers and they are absolutely great.

      Habib (ICT Tutor)

    • This was a clever one wasn’t it Peter? But please focus on fully understanding each lesson before moving onto the next lesson, and complete each lesson in order.

      Habib (ICT Tutor)

  15. I find it really cool as to what you can do within excel. Functions like these can be really helpful within the correct situation and can save a lot of time.

    Another tool in my excel toolbelt.

    Thank you for sharing!

  16. Thanks for this tutorial.
    I use excel but didn’t know about the existence of this option in the count function.
    I learned something new today.

  17. I used to work with excel a lot over ten years ago, and I loved it. I lost some practice, though, and this is why your courses are so great to freshen up on Excel again 🙂
    Thank you for this great lesson!

  18. Thanks for this tutorial…I’m so not comfortable using Exel, but I learned a lot. I always resort to my husband who’s an Excel wiz to create my spreadsheets if needed. Now I’m more at ease working with Excel. Thanks for your lessons!

    • You’re welcome Dana. Bookmark my site, and complete all the lessons, starting from lesson 1 and you will never need to ask your husband about excel anymore. I have made these tutorials so easy to understand. The functions have been explained thoroughly. Take care

  19. Thank you for sharing with us this information. I will save for future reference in my new office position.

  20. This is really amazing how you can count the test in a list, I am more and more amazed with every post I read from your website.

    Thank you for sharing


  21. Thanks for sharing the mystery of counting text using just the Count function – a clever trick to deduct the numbers. Thanks for sharing your other Excel lessons too.

  22. Thanks for sharing us on how to use the counting text function in excel. Especially when we create a sheet with many rows, we will need to use this function to manage our information sheet. Thanks again


Leave a comment

Share via
Copy link
Powered by Social Snap