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

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

  1. Insert a COUNTIF function TO COUNT MULTIPLE different items in a column

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 54: COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

Or go back to:

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

22 thoughts on “Lesson 53 – COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF”

  1. Habib,

    Using the COUNTIF function to count multiple different items in a column in Excel is such a useful feature to utilize. I appreciate you showing us different ways to use the function, too.

    Furthermore, using the less than and more than operators side-by-side is a rather clever technique to use, which I’m glad that you showed us in this lesson.

    Thank you for all of your hard work in preparing and presenting these valuable lessons to us. It is very much appreciated.

  2. Man, Everyday you come out with things I never thought of on excell spreadsheet and since I manage a website and other businesses I have been using some of these functions.

    Do they also work the same for google excel?

    I am asking because I use this mainly.

    • Hi Thabo,

      Answering to your question: Yes Google sheets is similar but nowhere near as powerful as Microsoft Excel. So, you can complete a lot of my lessons on Google sheets. However, some of the features may not be available and if they are, they will be located in a different position.

      Hope this answers your questions.

      Many thanks

      Habib (ICT Tutor)

  3. I’m learning so much from your lessons in how to use the different functions in excel. Another great, well explained and easy to follow tutorial.

    • Thank you so much Amy for your amazing feedback.

      Please share these lessons with your family and friends to benefit from.

      Best wishes
      Habib (ICT Tutor)

  4. Hi, Habib,

    Excellent tutorial. I just know how to use the “Simple” COUNTIF function. I don’t know we actually can put 2 COUNTIF functions into one formula. It is an eye-opener. Especially the last one with the exception requirement, I really didn’t know how to do it in the past. Thank you for sharing. I can have better uses of the COUNTIF function now. This has been a great lesson.

    All the best,


    • You’re very welcome Alex. Yes, there is amazing techniques that can be applied to these excel functions and extend them to do many different tasks for us. You can now go practice your newly found skill and knowledge from this lesson. Well done 🙂

      Habib (ICT tutor)

  5. Fabulous Habib. I think your site is a boon for all those who wish to learn Excel. This article has links for the most impossible things to do on Excel and that is all converted into videos by you. Thats such a huge help to people. Specialization is the key man, and u are totally nailing it.
    Well done.

    • Thank you so much Aprana for your kind words. I try my best to provide the the best of my ability contents.

      Please keep stopping by.
      Habib (ICT Tutor)

  6. Hello Habib, I just learnt how to use COUNTIF in Excel, and didn’t expect that it would have counting on multiple items with this function! See, Microsoft don’t really have this kind of lessons or training like you do here. I use Excel almost everyday, and I realized that I didn’t use it in full! I will follow the video few times, so that I will remember it. I hope I can learn more and please share more this kind of contents in future.

    Have a nice day and stay safe,

    • Dear Ling,

      Thank you for your feedback on the use of COUNTIF function in Excel. Glad to hear you have learnt this skills watching my video tutorials. I try to make my Excel lessons as practical and useful as possible. It’s great that this is working for people like yourself. I have many more Excel and more videos coming up so keep an eye out for them on our website and YouTube channel.

      Best of luck
      Habib (ICT Tutor)

  7. Hi, wow you really have a good knowledge about Excel,

    I would of love to have look at your website in 2005 when I was working for a company where I needed to do a lot of work on excel to calculate if I had enough men to work on every machines for every day of the week. You see I had to put the vacation, the seek days, the day off that they took and more. Thank you for sharing this post I really enjoy reading and leason to you video.

  8. Within a few mins into the video I had already learnt a lot about how to do COUNTIF function.
    Your demonstration is so precise and very documented so that any person can be able to follow and do it.
    I like that you provide us with an excel file which we can use to follow you. This makes it even easier to follow.

    • Hi Thabo,

      Thank you so much for your feedback. It’s great to know what I am doing right. Please keep the feedback coming in.

      Best wishes to you

      Habib (ICT Tutor)

  9. Wow, It has been so long since I have had to use this function in Excel, thanks for the refresher. Another great and easy to follow along tutorial! Can’t wait for the next lesson.

    • I’m so glad to know my tutorial are beneficial for you. I have many more videos coming up on Excel and whole Microsoft. So keep an eye out on my YouTube channel and website.

      Best Regards

      Habib (ICT Tutor)

  10. Great lesson, as always! This lesson is so helpful to people who don’t use excel regularly. This is a great training course. I didn’t even know you could count multiple items like this in excel. Without just doing it yourself. Great info!

    • That’s right. That’s one of the reasons why I made these videos to refresh some of the people’s memory if they don’t use it regularly.

      Glad it’s helping you though.

      All the best

      Habib (ICT Tutor)

  11. It’s getting more complicated by the lesson. But still, with your explanation I can follow the process, so that’s marvelous. I have to remember about this function, because it’s not something I have used until now.
    Thanks, Habib!

    • Hi Hannie,

      I’m glad to know you are still able to follow the Excel through my video. It’s really news! 🙂

      Hopefully you can follow the upcoming videos on our website and YouTube videos.

      Best of luck

      Habib (ICT Tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap