Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

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

  1. Be able to use a combination of the COUNT function to be able to count ONLY TEXT from a list or range of cells.
  2. Understand this mystery of counting TEXT only 🙂

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

If I have not covered anything 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 11 – What is the Merge & Center feature, and how to apply it in Excel?

Or go back to:

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

24 thoughts on “Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?”

  1. 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)

  2. 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!

  3. 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.

  4. 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!

  5. 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

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

  7. 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


  8. 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.

  9. 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