In this lesson, I’m going to be showing you how to:
- How to use the COUNTIFS function to COUNT MULTIPLE items from different categories or columns
- How to use the DATA FILTER feature to confirm our answers of the COUNTIFS 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 55: COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel
Or go back to:
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
I have always found this function extremely challenging, and I usually resorted to counting manually (which was very time consuming) or asking someone for help. With this tutorial, I am beginning to see how it works and I think that now I can finally use the countiffs function without any help. Thanks for that!
This is great to know that my Excel tutorials are helping you learn the Excel skills.
Wishing you all the best
Habib (ICT Tutor)
Hi Habib,
This video is awesome. I can learn a much more advanced technique in Excel. I don’t know this COUNTIF function in the past. It was very difficult for me if I want to do the same task. I need to count it manually by myself. Thank you, Habib. I now could use this function to count out something.
May I ask that how can I count the number of “HOURS” is less than or more than 21? What will be the formula looks like?
All the best,
Alex
Hi Alex, thank you and you’re very welcome.
To count less than and more a certain number of hours, you would use the operators (more than) before the hours. for example: >21 – that would be your criteria. Hoping this will help you out.
Habib (ICT tutor)
Very useful function! I can see that the COUNTIFS function would save somebody a lot of time and effort if needing to count items in more than one column. It is a very efficient way to work. Thank you for this important information.
You are welcome Susan. I’m glad my Excel video tutorials are more time efficient for you.
All the very best to you
Habib (ICT Tutor)
Hello, Great post, like I say Excel is my number 1 software to work with
Have a nice days
Lyne
Hi Lyne,
This is super! That means we have the same like for the Microsoft Excel.
Keep learning and sharing.
Habib (ICT Tutor)
I quite like the COUNTIFS function in Excel as presented in today’s lesson. It is a very useful feature and I can understand how it refines the data and accurately presents it.
Explaining how to use data filter in Excel within this lesson was a nice complement to the COUNTIFS function as presented earlier.
Thank you for another great lesson.
Hi Michael,
This is great to know! Thank you for your feedback. I have many more lessons planned e.g. Word, PowerPoint, Database, Publisher etc.
Best of luck
Habib (ICT Tutor)
I don’t know how you do it!! Your videos are VERY through and clear! Thanks again!
Hi,
Thank you! Glad you found them thorough and clear. Hope they have been useful for you too.
Best wishes
Habib (ICT Tutor)
Great content as always
I had no clue what this whole data filter although I heard it at school.
This will be useful for me because of the fact that I work on excel weekly for my businesses.
Most tutorials do not go as deep like you, Thank you again. I honestly feel you should create a course for this man. Information too valuable.
Yes, the data filter feature is amazing on Microsoft Excel. It allows quick filtering of any pattern of data that you want to see at a quick glance, and once you are done you can simply remove the filters.
Thank you for your feedback
Habib (ICT Tutor)
Thanks for the new training Habib! I didn’t know that COUNTIFS could use data filter and it helps me a lot! Because if use it for testing results, it’s really convenient and don’t need to waste lots of time, and I could become an audit too. But I need to watch few times more, and I will remember how to use this function. Keep going and I hope you can teach us more about Excel functions and how to use Excel in full.
Hi Ling,
You can use the data filter to confirm or audit in your case a lot of calculation in Microsoft Excel. This will save you alot of time, as you said.
Yes please, do watch the video lessons few times until you have fully understood everything I am explaining in the lessons. As understanding is the key to true knowledge.
Best of luck in your learning
Habib (ICT Tutor)
All your lessons are very useful for those who edit documentation in Excel. I like your way of transferring knowledge, which is simple, clear and understandable.
Thanks!
Nina
You are welcome Nina.
Glad my lessons are useful for you
Best wishes
Habib (ICT Tutor)
Thank u for this lesson Habib. I wish to thank u for making such great content available to us FREE of cost.
Aparna
Many thank Aparna for your comment and feedback. I want to give out my knowledge for Free so others can benefit from it.
Many thanks for stopping by.
Habib (ICT Tutor)