In this lesson, I’m going to be showing you how to:
- Use the COUNT function to count numbers in Excel
- Use the COUNTA function to count non-blank cells in Excel
- 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 (£) and apply 2 Decimal places to numbers in Excel?
Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?
Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
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
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
Rania
Thank you for your lovely feedback Rania.
Habib (ICT Tutor)
I love those kind of webinar , because are very very specifics and it solve “common” issues” that anyone have using Excel, keep that way!
Cheers.
Carl.
Thanks Carl. Appreciate your feedback!
Habib (ICT Tutor)
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
That’s great to know Thabo. It’s humbling to know my Excel video tutorial have been learning source for you.
Best wishes
Habib (ICT Tutor)
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)
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)
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.
Hi Julius,
Many thanks for your feedback and that my video lesson has been useful for you.
Wishing you all the best
Habib (ICT Tutor)
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!
Ashley
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)
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.
Pablo
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)
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)
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)
Thanks for another great lesson!! I will be coming back for each lesson to get the help I need!
That’s good to know! Thank you for your feedback.
Habib (ICT Tutor)
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. 🙂
That’s amazing! I’m glad my attached file was helpful.
All the best
Habib (ICT Tutor)
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)
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.
Thanks
Habib (ICT Tutor)
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)
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
Lyne
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)
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)