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

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

  • Use the Count function
  • Use the CountA function
  • What is the difference between the Count and CountA function

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 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Or go back to:

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

50 thoughts on “Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel”

  1. Hi Habib, In today’s lesson Count, and CountA functions, I have learned something new. Didn’t know the difference before. Thanks, for the clear explanation. I really have enjoyed your lesson!

    Reply
    • Hi Ola,

      Thank you so much for your lovely feedback and that my tutorial and teaching style is helping your learning.

      Wishing you all the best

      Habib (ICT Tutor)

      Reply
  2. Hi Habib,
    im really enjoying your lessons. Glad to have bumped into your website. Great way of teaching excel functions. Thank you for sharing your knowledge.

    Regards

    Janet.

    Reply
  3. Hi Habib,

    Thanks for this tutorial. It’s comprehensive, as usual. It will work very well when you want to cross-check the data in a complicated sheet with thousands of numbers, which I often meet at work. Now, I got a new formula to double-check my data quicker than before.

    Cheers,
    Matt

    Reply
  4. The Count and CountA functions are good ones to know in Excel. Not only is it good to know the differences between them, it is also good to know that blank cells are not counted with either of those functions.

    Another lesson where I learned something new. Thank you.

    Reply
    • Hi Michael,

      Many Thanks for stopping by and for leaving us a feedback. I’m glad you are learning the difference between these functions.

      All the best

      Habib

      Reply
  5. Hey, Habib,

    Excellent tutorial! I know most of these functions since I’ve been using them for years at work, but it’s always good to freshen up.

    I’d say I’m at an intermediate level, although I’d like to become an advanced user. For example, I’ve tried macros maybe once or twice, but since I rarely use them, I don’t have a lot of practice with those.

    Thanks for sharing. I’ll bookmark this for future reference.

    Reply
  6. Hi Habib,

    Thank you so much for these lessons! The fact that you offer them for free and teach us so much is amazing! I also love that your lessons are in video format, so we can follow along with you and with the whole process. That is immensely helpful!

    I feel like I’m pretty good at Word and PowerPoint, but Excel is the one that I really need to learn yet. You are helping me, and I’m learning so much!

    So, thank you again!
    ~Jade

    Reply
  7. Good to know!
    Your videos are very easy to follow, especially for a beginner like myself.
    Thanks for making it so easy.

    Many thanks,
    Andrew

    Reply
    • You are welcome.

      Thank you for the lovely feedback. I try to make my Excel tutorial as easy to learn a possible. Please do let me know if there is anything else in Microsoft Excel you would like to learn.

      Best wishes

      Habib (ICT Tutor)

      Reply
  8. Habib, thank you again for another interesting lesson. I like that they are quick and get straight to the point of the lesson. The examples are good and well laid out. One or two formulas per lesson aren´t going to overload the brain too much but it definitely makes things clearer, at least in my own head!

    Reply
    • Hi Susan,

      That’s the idea, i don’t want to overload you with too much information in one video. I try to do as best as I can to keep the steady pace going.

      Thank you for your feedback.

      Habib (ICT Tutor)

      Reply
  9. Hi Habib,
    I never would have a guess or figure out this myself that you need to use a function called COUNTA instead of COUNT.
    It definitely will come handy for my business.
    Thanks.

    V/r

    Reply
    • Yes Benson – COUNT on its own would only count numbers in a range, therefore COUNTA function is required. A lot of people struggle with this. Glad it will come handy for you.

      Habib (ICT tutor)

      Reply
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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