How to use COUNTIF and COUNTIFS Function in Microsoft Excel - For Beginners
HTML-код
- Опубликовано: 16 июл 2024
- 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
These functionas are awesome! I definitely will be using them at work this week!
Glad you like them!
That cell reference with comparative operator is the key ..... great work!!
Oh my gosh your a life saver!!! God Bless you, ive been trying to figure this out for over 30 minutes
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.
Jamie you make this so easy! Ive struggled with this in the past and now I get it perfectly clear. Thank you!
You are so welcome!
May God almighty continue to bless and enlarge your coast. You're a factory of excellence.
Your simplification is awesome
So well explained and very easy to follow. Thanks a million Jamie!
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. 🤩
Great masterclass Sir Jamie Keet
I really enjoy to learning Excel from your videos, its really helpful and nice explanation.
OMG so glad to have found this video
Thank you! This was explained so well and helped me get unstuck with something at work 😀
THANK YOU
great explanation! thank you
Thank you for these videos. Subscribed.
This is so helpful, thanks.
thank you so much
your videos helped me alot
Thank you for this great video.
Love it!
Thank you!
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.
nice tutorial, thank you sir
You are welcome
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.
Beautiful
really nice.
Nice video
Realy Nice
Thanks!
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.
Can I call myself " advanced in Excel" after watching and understanding your videos ?
Progress 😄
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?
There are so so many excel videos. What do you advise to take to learn excel from basic to advanced
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").
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
Once you have a count, how can you show what they are using the count?
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
Let me check
Practice sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv
@@TeachersTech thank you very much
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.
Chidi why can't you shoot your shot directly 😅, always going thru corners. I like that your improving in your acting, keep it up
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.