How to use COUNTIF and COUNTIFS Function in Microsoft Excel - For Beginners

In this video, I will show you how to use the COUNTIF and COUNTIFS functions to create formulas in Microsoft Excel. I will demonstrate how to use the COUNTIF with one criterion or COUNTIFS with multiple criteria. Also included in this Excel functions tutorial is how to use wildcards in your formulas.
Practice sheet: leveragingdigitalinc-my.share...
More Excel Function Tutorials: • Formulas and Function ...
I'm using Office 365 in my demo.
0:00 Introduction
1:14 COUNTIF Formula with numbers
3:04 COUNTIF with numbers greater than
4:45 COUNTIF with letters or words
5:30 COUNTIF with operations
7:25 COUNTIF with wildcards (asterisk and question mark)
11:00 COUNTIFS multiple criteria

[@Shriraj27]

That cell reference with comparative operator is the key ..... great work!!

[@DemetriPanici]

These functionas are awesome! I definitely will be using them at work this week!

[@TeachersTech]

Glad you like them!

[@OliviaPorcher]

Oh my gosh your a life saver!!! God Bless you, ive been trying to figure this out for over 30 minutes

[@user-jv4bj2ph4u]

So well explained and very easy to follow. Thanks a million Jamie!

[@Crybaby-cz8et]

All Teachers tech videos have helped me understand excel better. It was so intimidating especially with formulas. Even though I still get confused with my work spreadsheets, I'm getting there day by day.

[@amienaziz7701]

THANK YOU

[@meatiethatsme2471]

Jamie you make this so easy! Ive struggled with this in the past and now I get it perfectly clear. Thank you!

[@TeachersTech]

You are so welcome!

[@collinsomoregbe2630]

May God almighty continue to bless and enlarge your coast. You're a factory of excellence.

[@tafiqulbarirabbi2000]

Great masterclass Sir Jamie Keet

[@jkawpiper]

Thank you Thank you!!! This was very helpful for my project. It helped that you reviewed multiple methods and both SUMIF and SUMIFS. Exactly what I needed. 🤩

[@jaz_ofalltrades]

OMG so glad to have found this video

[@FaysalEasyExcel]

Your simplification is awesome

[@gk-wi6hg]

I really enjoy to learning Excel from your videos, its really helpful and nice explanation.

[@biodunwilliams8752]

Thank you for these videos. Subscribed.

[@queenkai9522]

Thank you! This was explained so well and helped me get unstuck with something at work 😀

[@robynlindenberg6751]

This is so helpful, thanks.

[@Princess02732]

great explanation! thank you

[@ashup2782]

Thank you for this great video.

[@jayzee5039]

thank you so much your videos helped me alot

[@user-gu8dc1ur2t]

Love it!

[@niteeshbihade1789]

Thank you!

[@MrJimmy463]

Very helpful, I was wondering if you could make a short video on how to take a block of cells , that are not a header or footer and freeze them to move with the page up and down. If you could that would be great thank you.

[@prakashbhattarai5550]

really nice.

[@techtimes1985]

Beautiful

[@MujelTech]

nice tutorial, thank you sir

[@TeachersTech]

You are welcome

[@wandagreer9144]

Another great job on this video, Jamie. Thanks. I am having an issue with getting circular reference errors. Maybe I am not coding the correct formula? I am new to using Excel (less than a month). Can you please do a video on this? I am taking 2 columns and subtracting a 3rd and placing the results in another column. Call them A+B-G results in column M. Now, I need to use the results in M and multiply that by column O which is a percentage and place those results in column B. Is this possible? Is that the problem? When I copy the formula down in B, I get a blue arrow connecting columns on other rows with the error dialog box popping up saying I have a circular reference. Am I not allowed to use the results of one calculation to create another calculation? Is it trying to do the multiplication before the addition so that the value in M is non-existent? Must I have these columns adjacent to each other or can they be spread out over the sheet as they are? I have been working on this for days, am I making sense? Please help? Thanks.

[@uexcelinmsoffice4323]

Nice video

[@numair3]

Realy Nice

[@TeachersTech]

Thanks!

[@cheryltolentino704]

Can “countif wildcards” be applied for data across multiple worksheets? For example, I want to determine how many times a name appears in a current worksheet and all other previous worksheets.

[@abdulrahmanjamal1122]

Can I call myself " advanced in Excel" after watching and understanding your videos ?

[@lisamichele72]

There are so so many excel videos. What do you advise to take to learn excel from basic to advanced

[@pippyfari]

Hi Jamie, thanks for this, it was inspiring to say the least! I was wondering if you could help (this maybe down to my own understanding or lack of it, rather than your clip). I am working on a spreadsheet and I need to find a formula that demonstrates if a number greater than 0 appears in more than 1 cell, for example in a football game, Team A V Team B, the final result is 2-1 and so Team A have won. What I need to identify is if that both teams have scored then the formula would display a result as YES or NO, or 1 or 0. Can you help?

[@blairvalentinewandya1427]

Progress 😄

[@onielcleary894]

Question I have a drop-down menu in my spreadsheet I used the Countif Function to count the total of the item now I am trying to Subtract from that item when drop down is listed as deployed Example =COUNTIF('Inventory List'!E5:E209,"p135g")-COUNTIF('Inventory List'!B5:B360,"deployed") Keep Getting 0

[@godwinuche4669]

You said you dropped the practice file link so we can download and follow along in this lesson. I couldn’t find it anywhere here in the description below

[@TeachersTech]

Let me check

[@TeachersTech]

Practice sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv

[@godwinuche4669]

@@TeachersTech thank you very much

[@Richard-mq7wf]

I'm trying to get a simple COUNTIFS formula to work where if G3 is greater than 59 and G4 is "Over" it counts 1, BUT I need to do that for multiple sets(ie.G6 is greater than 59 and G7 is "Over"...G9 is greater than 59 and G10 is "Over"...etc. and give me a count for all of those instances. I tried the following but it counts "0" (=COUNTIFS(G3:G56,">59",G3:G56,"Over").

[@whmosher7599]

Once you have a count, how can you show what they are using the count?

[@derekviveiros]

DOES ANYONE KNOW....How do we count the number of cells in a range that have a hyperlink that was entered via the 'insert link', and that also have text displayed in the cell? The link isn't in the cell display, which is how all your examples work.

[@KenechiObi-gz7rn]

Chidi why can't you shoot your shot directly 😅, always going thru corners. I like that your improving in your acting, keep it up

[@e5establishment553]

Head Name Count A peter yes A will no B peter no B will yes A mark yes B mark yes A peter no B mark no This above said details are my Data. But i want following type of results. Head Name How many yes How many No A peter 1 1 will 0 1 mark 1 0 B peter 0 1 will 1 0 mark 1 1 Total 4 4 What is the formula for this result.