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

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

  • Understand, what a COUNT function is
  • Insert a COUNT function
  • Understand, what a COUNTA function is
  • Insert a COUNTA function

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 7 What is the ROUND function, and how to insert it in Excel?

Or go back to:

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

30 thoughts on “Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?”

  1. Hi Habib,
    This is a very interesting video. You are really a good teacher because you explain everything from A to Z. I studied excel a few years ago and uses it in my work, You reminded me of some information. Besides, I learned new ideas.
    Wishing you great success in your business
    Rania

    Reply
  2. I am useless at this stuff so all these guides are really helpful, and step by step in nature. I am certainly learning from them and also about things I did not know exsisted! Thanks for sharing, Phil

    Reply
  3. Hi Habib. This was a great tutorial. Your explanation of the difference between COUNT and COUNTA made it really easy to understand. Thank you.

    Reply
    • Hi Samantha, it is my job to explain the functions and breakdown any complicated terminology, so that everyone can benefit and learn easily by following my tutorials.

      Habib (ICT Tutor)

      Reply
  4. Dear Habib
    Thank you very much for your fantastic website. It is amazing that you show people where to start and what steps to take towards their proper understanding of Microsoft Office programs and their value for everyone. I hope more people will know about your website and follow your guidance.
    Kind regards,
    Andrey

    Reply
    • Thank you Audrey for such beautiful words. I’m happy to hear you like our website. I always try my best to teach or demonstrate skills of all Microsoft office package – here I’m showing and explaining how the count and counta function works. Feel free to share with your family and friends. Take care

      Habib (ICT Tutor)

      Reply
    • Like yourself many others are also only aware of the COUNT function, which only counts the cells with numbers in. But when it comes to count the cells which contain text you must use the COUNTA function. A tiny difference, but it makes a huge difference. Take care

      Habib (ICT Tutor)

      Reply
  5. I use a lot count function on a daily basis but haven’t used counta yet. Very practical video and I see you have a lot of training here about other excel functions, which is amazing. It is a great tool but we don’t use even 10% I’d say of it all. Thank you for sharing.

    Reply
    • Counta is very useful, when you have an inventory or something similar that needs counting automatically regardless of what type of information the cell contains. Many people don’t use excel with its true functions – they just use the basics.

      I will be having many more tutorials like this one, but I recommend you start from lesson 1, to make the most of my tutorials.

      Habib

      Reply
  6. Very interesting and informative article. I haven’t been using a spreadsheet in a long time but your article comes handy as I could learn something new or maybe remind myself of these excel functions (count and counta ). I’ll definitely make time for this.

    Thank you so much

    Maggie

    Reply
    • The functions count and counta, will help you count the number of items for you automatically instead of you having to do it manually. If the number of items change it will automatically recalculate for you. It’s amazing!

      Glad you are learning something new. Many more tutorials to come yet. Regards

      Habib (ICT Tutor)

      Reply
  7. Hi Habib

    I’m also a frequent user of MS Excel and I’m familiar with the functions you have posted here, but in times there are functions that we use frequently and functions that we use on special cases.

    This post reminds me of those functions that I don’t normally use and I’m happy that you have reminded me of that.

    Thank you for this information.

    MadyibiLG

    Reply
  8. Thank you so much for this highly informative article! I have used Excel numerous times in the past, though I, oddly enough, have never used the Count or Counta function (at least not to my knowledge). You did an excellent job of breaking down what the functions are, what they do, as well as how to do them. I greatly appreciate thorough explanations of how to implement these functions into my everyday Excel life (some “how-to” articles are rushed, don’t make sense, and leave readers with more questions than answers). I have saved your article and will definitely share it with my friends and family. God bless you!

    Reply
    • Thank you for your very kind words – I always do my best to explain any given skill before demonstrating to my viewers how to implement it – understanding is the key to true knowledge. God bless you too. Take care

      Habib

      Reply
  9. Hi, this is very interesting. I use Excel a great deal for work and I am quite accustomed to using the sum, power and average functions but I have never encountered the count or counta function. I could see how it would be useful particularly for people who have inventory held in Excel tables. I am using Excel more and more for financial simulations so it is good for me to check out the programming capabilities. I suspect it is a more powerful piece of software than I have hitherto considered.
    Thanks for this eye-opener
    Best regards
    Andy

    Reply
    • The Count function works wonders to list counts of any kind – many people are not aware of this hence don’t use the count and counta function.

      Most don’t even know that, there is a big difference between the 2 cunt functions. Thanks for your comment.

      Habib

      Reply
  10. Hi Habib,

    Thank you for an informative presentation, one which is extremely useful to me.

    It’s been a number of years since I’ve used excel, but I’ve recently started producing spreadsheets, etc. for work.

    I’ve been going through some of my old notes, but to be honest it’s far easier to just follow your guidance here.

    Thanks for helping me out and keep up the great work.
    Partha

    Reply

Leave a comment

Share via
Copy link
Powered by Social Snap