🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I spent hours trying to figure out how to get a formula like this to work for the data I was trying to organize and this was the magic video that stopped my search. THANK YOU!
I paid so much money to a course through a local university to learn Office and I end up on your videos because you explain it so much better than they do. Thank you!
Thank you - I support multiple programs, and have a spreadsheet for the personnel I'm responsible for with their program & location noted. But couldn't figure out how to set up running tallies of different data points for the inevitable "need the info yesterday" data calls without getting a !SPILL error. I'd figured out how to use COUNTIF, but not how to combine multiple programs or locations without having multiple queries then SUM those cells. Using your walkthrough, I just set up 4 different COUNTIFS that have info I am often asked for, so I can now respond to "Need NOW" emails as fast as I can pull up the spreadsheet. You've saved me a lot of time & stress, thank you.
I really really hope Microsoft was paying you extra for these videos bc I know a lot more people are using excel bc of you. Everyone in my office watches your videos from old to young either to brush up or to learn something new. As always, thank you for your videos Kevin and not just for Microsoft products but all the programs/system you teach us how to use (I literally learned how to edit videos from your other videos too)
I am a brand new accounting student. Literally in my first unit, in my first semester. You sir are a life saver! Thank you so much, you have a new subscriber :-)
I am addicted to your videos because I became very confident that after watching them, I can call myself an expert in what I just learned. Thank you so much, Kevin! 👍👍👍
I really like your explanation. Clear and very easy to follow. You help a lot of people how to use and understand excel, keep it up bro.! You are a blessing to many. God bless you!
Hey man, thanks a million for the help. I'm working on some modules for work and the instructions that we're given are completely vague and lacks proper directions. THIS was insanely helpful. I just hit the subscribe button. Thanks again.
Wow thanks bro, youve literally saved me hours of work. Its not that I didn't know the formula, but I was underperforming it. I didn't know that the "range" could deal with multiple sets of data at once. I was using this function for each row for thousands of samples instead of using the "range" to combine everything and calculate a full table of data in one cell....not sure if you get me, lol but thanks this helped
Hey Kevin, what if I wanted to show my results on a different sheet? For example, on 11:29, what if I wanted to show the results of the "East region with at least 400 orders" on a separate sheet from the Multiple Criteria sheet? I'm curious to know how the formula would look on that.
I want to show or plot my data for example the 400 results like dots in a graph. Or at least mark them with a colour to identify them, could this be possible?
This awesome. I really loved the "wild card" tutorial on how to count "start with" and "end with". I will be using this feature a lot. My biggest issue is how to copy the formula and paste to multiple columns without changing the formula. I always have to do redo the formula for each column. I'm teaching myself how to do metrics and I work with a company that have 32 groups and always have to show results for each month or for multiple criteria.
Thank you Kevin. Liked your countif presentations.Simple and variety of countif , countifs were simple and easy to understand. 🎉 Please feature power query importing and cleaning financial data from SAP, ORACLE; csv, pdf
This is so helpful! Thanks Kevin! A quick question - how do we calculate, in this case, total orders based on a specific region? Eg: total no of orders by the east region sales rep
at around 12:00 you begin to enter the second criteria for your "countifs" equation, my question is can I use the same criteria range for both criteria? I tried using your exact formula but using "civil" for my first criteria and "structural" for my 2nd instead of ">=400". My total was zero but should be at least five. Any help would be very much appreciated
nice job. this really helped with my spreadsheet for work. i had 2 sheets that didn't balance...i suspected the 300's were the difference...actual error was 299.20 . used the countif to work out one sheet had 41 on, other had 42. not only was this quicker , it was far more accurate than if i'd done it manually. very useful trick as i often get this type of issue. ( having found the big diff, i then zero'd in on the smaller diff of 0.80 soon anyway ! :) )
Very good video. It would be great to include "extra" tips by mentioning you can select the whole range by using shortcut keys. If the range extends two or more screens click and drag would be a drag (pun intended). Excellent video though. Thans.
Thanks for sharing this Kevin! I’m training myself for a roll in accounting area. I have a question tho, at 10:26 “???e” shouldn’t green also count? Its e is in the 4th position.
Great tutorial Kevin, however, I have single cells in my spreadsheet with multiple numbers that I'm trying to summarize. For example cell E:7 contains the numbers 2,3,5,7,9, 12. I want to ask Excel to tell me how many times the number "2" appears in cell E:7. I think this isn't possible no matter where I put the wildcard asterisk as Excel is reading all my number entires as one single number. ANy suggestions would be appreciated. Thank you.
For the red and yellow example, instead of adding 2 countif formula's can I just use countifs instead? What is the difference between count multiple items and countifs?
Hi Kevin, thank you so much for this video, it is very helpful. I'd like to ask, in a spreadsheet that contains records with duplicate information, how can one count the number of "unique" records (excluding the duplicated data)? For example, in you first sheet, there are multiple colours in the first column... How the do you count the number of colours (as in DIFFERENT colours) in that column in a very large database. Thanks.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Kevin, thanks for the post but the link opens into the list of your how to for PowerPoint. Can you post the correct link to the Excel videos?
I`d like to see your list of Excel videos as that`s what I`m learning at the moment, thanks (11/01/2021)
Kevin, please post the correct link to your list of Excel videos.
Sorry about that! I’ve updated the link.
Your'e the best❤...your videos are my go to for everything I need. Thanks so much!
This has been the most easy to understand COUNTIF/S tutorial for BEGINNERS like me.
Very helpful, thanks!
I spent hours trying to figure out how to get a formula like this to work for the data I was trying to organize and this was the magic video that stopped my search. THANK YOU!
I paid so much money to a course through a local university to learn Office and I end up on your videos because you explain it so much better than they do. Thank you!
You're the best because 'when you teach something you cover each and every aspects of the topic'. Thank you ever so much
I AM NEW TO EXCEL, I DID NOT ONLY LEARNT COUNTIF AND COUNTIFS BUT ALSO THREE MORE USEFULL THINGS I DID NOT KNEW AND TEACHING STYLE IS BEST.
Thank you - I support multiple programs, and have a spreadsheet for the personnel I'm responsible for with their program & location noted. But couldn't figure out how to set up running tallies of different data points for the inevitable "need the info yesterday" data calls without getting a !SPILL error.
I'd figured out how to use COUNTIF, but not how to combine multiple programs or locations without having multiple queries then SUM those cells. Using your walkthrough, I just set up 4 different COUNTIFS that have info I am often asked for, so I can now respond to "Need NOW" emails as fast as I can pull up the spreadsheet.
You've saved me a lot of time & stress, thank you.
Man, you just saved my week, didn't know about that ">"& to reference a cell.
I really really hope Microsoft was paying you extra for these videos bc I know a lot more people are using excel bc of you. Everyone in my office watches your videos from old to young either to brush up or to learn something new. As always, thank you for your videos Kevin and not just for Microsoft products but all the programs/system you teach us how to use (I literally learned how to edit videos from your other videos too)
5:00 first check point
6:52 second check point
8:24 third checkpoint
10:55 final lap
FINISHED!
I am a brand new accounting student. Literally in my first unit, in my first semester. You sir are a life saver! Thank you so much, you have a new subscriber :-)
I didn't know that the "=COUNTIFS" function requires 2 sets of condition for it to work. This video helped it break it down for me. Thanks alot!
You just cleared my one month lesson in one video... thank you soooo much.. you saved me😄
I am addicted to your videos because I became very confident that after watching them, I can call myself an expert in what I just learned. Thank you so much, Kevin! 👍👍👍
Great to hear!
Very simple approach to COUNTIF, COUNTIFS. Brilliant!!
I really like your explanation. Clear and very easy to follow. You help a lot of people how to use and understand excel, keep it up bro.! You are a blessing to many. God bless you!
I think out of this whole video the fact that you called the '&' by its real name was, most awesome, I had to look it up.
Kevin, this video helped me so much with a project that I'm doing right now. No one else could help me with the count question! Thanks so much!!!
Another quite simple and direct and accurate video! My ADHD thanks you, good Sir, for a job well done!!!
This is really helpful. I've been searching how to count how many B if A in two different rows.
Tysm these videos have really helped with revision for my upcoming test! Wish me luck it's tomorrow
you know how to teach, you made it easy with ease and patience, thank you. will base my search on your channel then:)
Thank you so much this was driving me crazy
With the help of this video I solved my headache worksheet. Thanks alot Mr.Kevin Stratvert. God bless you.
I really learned a lot from this. Rich examples and great delivery. Thanks for all you do
Great and infomative video! Very easy to understand. great Job!!!
You could not ask for this to be any clearer. Thanks!
I really learn so much with your videos very well explained, THANK YOU!
So usefull and simple, keep it up man.. greetings from Turkey 😉
Great video very informative to understand. You're a good teacher. Thank you.
Kevin! Kevin! Kevin! You are a star. Thanks for this great video
Thanks so much
I can never forget this tutorial. So helpful
Hey man, thanks a million for the help. I'm working on some modules for work and the instructions that we're given are completely vague and lacks proper directions. THIS was insanely helpful. I just hit the subscribe button. Thanks again.
Just fantastic! I appreciate your time to make this very helpful video.
Thanks so much, you save me hours of head aches
You're a real hero dude. Thank you
Wow thanks bro, youve literally saved me hours of work. Its not that I didn't know the formula, but I was underperforming it. I didn't know that the "range" could deal with multiple sets of data at once. I was using this function for each row for thousands of samples instead of using the "range" to combine everything and calculate a full table of data in one cell....not sure if you get me, lol but thanks this helped
Hey Kevin, what if I wanted to show my results on a different sheet? For example, on 11:29, what if I wanted to show the results of the "East region with at least 400 orders" on a separate sheet from the Multiple Criteria sheet? I'm curious to know how the formula would look on that.
I want to show or plot my data for example the 400 results like dots in a graph. Or at least mark them with a colour to identify them, could this be possible?
Thats my exact problem with our assignment
Year 2024 and it is still helping. Thanks Kevin for the good work!
This awesome. I really loved the "wild card" tutorial on how to count "start with" and "end with". I will be using this feature a lot. My biggest issue is how to copy the formula and paste to multiple columns without changing the formula. I always have to do redo the formula for each column. I'm teaching myself how to do metrics and I work with a company that have 32 groups and always have to show results for each month or for multiple criteria.
After you copy the formula, hit the "ESC" key, then paste the formula in another cell.
Thanks
thank you so much for your good lesson!!! very straight to the point and easy to comprehend !
This is super helpful. Thanks, Kevin! 😊
You are brilliant. You,be very helpful to for almost 3 years now. 👍😎
Awesome bro ! love from India
Thanks for helping as revision for my test tomorrow! :)
Thank you Kevin. Liked your countif presentations.Simple and variety of countif , countifs were simple and easy to understand. 🎉
Please feature power query importing and cleaning financial data from SAP, ORACLE; csv, pdf
Straight to the point ! Thank you!
great work sir nice explanation and easy to get it
At 4:23 of the video, we put " " around ) or lesser than (
Perfect! This is exactly what I'm looking for! Thanks a lot. It'll help me creating my tracker 🥰🥰🥰🥰 Awesome
This is so helpful! Thanks Kevin! A quick question - how do we calculate, in this case, total orders based on a specific region? Eg: total no of orders by the east region sales rep
Good stuff here. Just used this to fix a major problem with accountability on a spreadsheet used by a group for work reasons.
This made my job easier, thanks!!!
THANKSSSS....after checking so many videos, finally I got here what I was looking for!
This so helpful, Thank you Kevin.
Thank you for the awesome tutorial!
Thanks Kevin for your efforts on the countif/s functions... great work and very helpul.
omg!!! you are amazing, your help is soooo valuable!!!!
at around 12:00 you begin to enter the second criteria for your "countifs" equation, my question is can I use the same criteria range for both criteria? I tried using your exact formula but using "civil" for my first criteria and "structural" for my 2nd instead of ">=400". My total was zero but should be at least five. Any help would be very much appreciated
Tqvm for all the guidance especially for beginner.
Brilliant. Clear and straight to the point. Easy to understand. Thank you
Thank you, well explained...Now to put in to practice.
Thank you Kevin, it really helped me a lot
You saved alot of my time thank you so much for sharing this information. 💜
Your the answer to my Hows, thanks alot..
excellent class ,, thank you so much kevin
+1 Subscriber and gonna ask my hubby,sisters to follow you... I love you ♥️
you explain it better than my teacher
Thank you so much for this video Kevin!
Thank you for your precious sharing.
Great. Thank you for share your knowledge..👍
nice job. this really helped with my spreadsheet for work. i had 2 sheets that didn't balance...i suspected the 300's were the difference...actual error was 299.20 . used the countif to work out one sheet had 41 on, other had 42. not only was this quicker , it was far more accurate than if i'd done it manually. very useful trick as i often get this type of issue. ( having found the big diff, i then zero'd in on the smaller diff of 0.80 soon anyway ! :) )
great video, just insert the workbook here for practice
Thank you I understood almost everything
Very good video. It would be great to include "extra" tips by mentioning you can select the whole range by using shortcut keys. If the range extends two or more screens click and drag would be a drag (pun intended). Excellent video though. Thans.
easy to understand and follow Thank you
Awesome, thanks for this! 👍🏼 putting together a huge tracking spreadsheet for work and this formula is a life saver
Thanks Kevin, these are some sick function tips
At 9:27 of the video, does "m*" include the cells containing just the letter m itself and does "*e" include the cells containing just the letter e?
Thank you! That document really helped.
Thanks for sharing this Kevin! I’m training myself for a roll in accounting area. I have a question tho, at 10:26 “???e” shouldn’t green also count? Its e is in the 4th position.
No, cuz GREEN has 5 letters
wow! very clear explanation! Thanks a lot!
Nice and very helpful video.👏 Subscribed😊
12:50, if you had a second column "Revenue2" with numbers and you wanted to compare which lines revenue1>revenue2, how would you find that?
=SUMPRODUCT(N(A2:A10>B2:B10))
This formula works in my sheet.
revenue 1 revenue 2
1915 1570
1620 1188
1874 1063
1108 1296
1586 1035
1884 1642
1522 1698
2011 1947
1163 1388
At 5:53 of the video, to find out which numbers are greater than and equal to 1 and lesser than and equal to 9. Can we do =countif(range, "1
thanks for the info, it's very helpful ! I appreciate it a lot
Very helpful! Thank you!
Very much interesting & useful also. Keep making this type of videos .
Thank you very much. Very helpful
Thank you so much! Such a great video.
Great tutorial Kevin, however, I have single cells in my spreadsheet with multiple numbers that I'm trying to summarize. For example cell E:7 contains the numbers 2,3,5,7,9, 12. I want to ask Excel to tell me how many times the number "2" appears in cell E:7. I think this isn't possible no matter where I put the wildcard asterisk as Excel is reading all my number entires as one single number. ANy suggestions would be appreciated. Thank you.
Thank you very much my brother
For the red and yellow example, instead of adding 2 countif formula's can I just use countifs instead?
What is the difference between count multiple items and countifs?
Very good and to the point
Very helpful video
Hi Kevin, thank you so much for this video, it is very helpful. I'd like to ask, in a spreadsheet that contains records with duplicate information, how can one count the number of "unique" records (excluding the duplicated data)? For example, in you first sheet, there are multiple colours in the first column... How the do you count the number of colours (as in DIFFERENT colours) in that column in a very large database. Thanks.
Yeah, this is what I am trying to figure out too
Very helpful! New subscriber here.
Thx for teaching us -
10:26 "green" contains "e" at position 4, but not counted. How to avoid this?
that's so helpful. thanks a lot