Lesson 55 – COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

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

  1. Use the COUNT function to count numbers in Excel
  2. Use the COUNTA function to count non-blank cells in Excel
  3. Use the COUNTBLANK function to count blank cells in Excel

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 56: SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?

Or go back to:

Lesson 54: COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF

Lesson 52: COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

Lesson 51: How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48: How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47: How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46: Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45: How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44: Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43: How to change a DATE to different FORMATS in Excel

Lesson 42: How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41: How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39: How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24: How to SORT data in ASCENDING order in Excel

Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

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

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

34 thoughts on “Lesson 55 – COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel”

  1. Hello Habib
    I really become an expert in Excel because I watch your videos. I always look forward for a new video. Your effort is very much appreciated. Wishing you great success

  2. I love those kind of webinar , because are very very specifics and it solve “common” issues” that anyone have using Excel, keep that way!



  3. Thank you to your tutorials I have been improving on my excel skills and I can say that I have more skills and the count Function is what I needed as I was struggling with putting some calculations for my business. Thanx

  4. Hello Habib, I always learnt something when reading your post and video training. This is another useful tips in Excel. I always use SUM instead of COUNT, but what are the difference between both of it? I’m still a bit confused. For me it starts becoming hard and guess I will take few times to watch your training videos. Your trainings are useful and informative, and it helps a lot of people and convenience in daily life.

    • Hi Ling. SUM, basically means adding, hence your adding; for example 5+4. Whereas, COUNT is to literally counting how many items there are in a range. Hope this answers your questions and helps you out. Take care Ling 🙂
      Habib (ICT tutor)

  5. Hi Habib
    Thank you so much for this tutorial. I used to have no idea how to make calculations on the spreadsheet when I first started at work.

    I wish I had met your site earlier it would have been a lot easier as you explain these things with ease.

    Thanks once again.

    • Hi maggie,

      Many thanks for your lovely feedback and also for leaving the comment on this post. I am glad to hear my video tutorials on Excel have been useful for you. Keep learning and also please don’t forget to share these Microsoft Excel lessons with your family and friends, so they can also benefit from them.

      Best wishes

      Habib (ICT Tutor)

  6. Thank you Habib for another lesson. This particular task was always hard for me. I never managed to set up the COUNT function in the right place. Now , that I see it in real practical example I am looking forward to be more skillful in this particular task. Excel is far more easier with your guidelines.
    Thank you.

  7. Wooow! This is an awesome lesson! I had no idea that all of this could be done this way; using Excel.
    You make it look so simple too. It’s good when you have a tutor that knows how to explain things in such a way that anyone can understand.
    Great job!


    • Hi Ashley,

      Thank you for your amazing feedback. I shall carry on creating more lessons and being fabulous.

      I really appreciated your comment. Please do visit our site and YouTube channel again.

      Many Thanks

      Habib (ICT Tutor)

  8. Wow this is a great article but I am more thrilled by the whole series.
    I am a Financial Controller, thus I work a lot with Excel and having this site as a reference point is great. I am going to try COUNTIF and see what else to bookmark.


    • Hi Pablo.

      This is so good to hear! I’m so glad my series of Excel lessons are useful for you. Please let me know if they is anything else I’ve not covered yet and you would like to learn about.

      It’s a pleasure to be helpful in your day to day job using Microsoft Excel.

      All the best

      Habib (ICT Tutor)

  9. I love the COUNT functions in Excel, including COUNTA and COUNTBLANK. All of these functions are very helpful in Excel.

    Thank you for informing us that a space in a cell counts as a numerical value/data as that is something that I did not know about before this lesson.

    Best regards

    • Hi Michael,

      I am thrilled to know my lesson was helpful for you and you have learnt about the space in cell counts. I have many more lessons already on our YouTube channel and many more are on their way.

      Many thanks for watching my Microsoft Excel video tutorials.

      Best wishes

      Habib (ICT Tutor)

  10. Hi
    This is very helpful and informative. Your lesson is clear and easy to understand. Now I know where to get help if I’m stuck in Excel.
    Thank you for the tutorial.

    • Hi Sarina,

      Many thanks for your useful feedback. It’s appreciated. Glad to know my lessons on Microsoft Excel are helpful for you. I have many more video tutorials on our YouTube channel. Feel free to check them out.

      Best wishes

      Habib (ICT Tutor)

  11. This is another excellent tutorial, and I loved that I was able to download the excel file and work with it while listening to your explanation and instructions. Having this hands on practice is so helpful. 🙂

  12. Thanks for creating an awesome video for the count function. I was trying to count up some of the items in my list and had to do it manually until I decided to use excell but then didn’t know how to use the formula until I came across your website.

    All I can say is thank you for making it so clear and very time saving. I used your technique and now I can seperate the items in my list like ‘magic’. lol
    Keep up with the lessons I love them, can’t wait for the next one.

    • Hi Rick,

      Thank you very much for your detailed feedback. That was one of the reasons for making these video tutorials on Microsoft Excel so I could share my knowledge with those who would like to learn these useful techniques used in Excel, or simply brush up on their Excel skills.

      Wishing you all the best

      Habib (ICT Tutor)

  13. Hi Habib.

    Thanks for another helpful and informative post. Your site is always the one I come to when I’m stuck with excel or anything IT for that matter. Keep up the good work.

    • Many Thanks for stopping by and providing your valuable feedback. Please let us know if you would like to learn anything specific in Microsoft and I will try to do a video on it.


      Habib (ICT Tutor)

  14. Ohh, so far I have only used the COUNT function. Never knew there were other methods to count as well. It’s always great to learn something new, so thanks, Habib, for your explanation!

    • You are welcome Hannie. Glad to hear my lessons are useful for you and you are learning new methods on Microsoft Excel.

      Wishing you best of luck in your learning

      Habib (ICT Tutor)

  15. Hello Habib, I watch your videos and I really found that you explain very well how to use excel. I had to work on Excel this morning and I was happy to work on it because I love working with Excel.
    Thank you for sharing this information with us

    • Hi Lyne,

      Glad to hear that! That was the main reason for making these videos to enable people learn the Microsoft Excel, all for FREE.

      Thank you for your lovely feedback.

      Habib (ICT Tutor)

  16. I never knew excel could do such amazing things! The software is more awesome than I ever thought! Thank you for breaking every part of it down so clearly! I would be no where without your guidance!

    • You are right. Yes the Microsoft Excel is a very powerful software and it can be very daunting without the right guidance. This is why I have created these series of lessons so all my fans can benefit from it. I hope you have understood all these functions (COUNT, COUNTA and COUNTABLANK).

      Best wishes

      Habib (ICT Tutor)


Leave a comment

1 Share
Share via
Copy link
Powered by Social Snap