12 Excel FUNCTIONS Made Easy [SUM, SUMIF, COUNT, COUNTIF, MAX, MIN.....] | ExcelJunction.com
Practice file for DOWNLOAD: www.exceljunction.com/12-excel...
The most used functions in Excel are the ones that sum and count. You can sum and count based on a single or multiple criteria. This lesson covers:
SUM, SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MIN
Пікірлер: 380
This is explained in such a simple manner, thank you, sir ............
Am so much grateful, the turtorials are so helpful. It was hard to understand my college tutor in limited time. Now I have found stressfree help.
You are good teacher, thank you for this video.
Thanks a lot , you are one of the best teachers in the world of Excel!
@Exceljunction
5 жыл бұрын
Thank you so much for your kind words. Just trying to do my bit. Such appreciation by viewers is very encouraging. Will try to come up with more useful lessons.
First time i saw the most easiest way to use IF formulas thats awesome
@Exceljunction
7 жыл бұрын
Thanks for appreciating Moeez. Do subscribe the channel and share with your friends too. Best Regards
I actually got this question (the one uploaded as the PDF) as the annual project !! At first, i couldn't do it, but then for god's sake, I found out the source (this video) and so it made my life a hell easier...Easily explained, this was a gr8 vvideo....!!
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Just going for an interview and had a look over it and now im clear about the functions. Thank you sooo much sir.
@SaiTeja0805
5 жыл бұрын
Which company you are working?
This is explained in such a simple manner, thankyou so much.
@Exceljunction
6 жыл бұрын
Thanks for appreciating.
@akinyetunpraise6742
5 жыл бұрын
I'm in trouble with my table. I can't tell it here. How can i contact you
@Exceljunction
5 жыл бұрын
Please post your query on our WhatsApp group www.exceljunction.com/whatsapp-group/
Thanks for the terrific job, it solves almost all of my daunting task.
Plese explain during putting any formula how can I understand where I putt Bracket & comm (," ") as i show on the comment Beause i don't know (where_ when_ what) I think You understand pleas upload detail video
perfect! I did not understand a thing when our teacher taught us. Thanks for video need more of them and subscribing you
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
You did an excellent job explaining how each one works!! Love it!!
@Exceljunction
6 жыл бұрын
+TT Matt Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Awesome! Easy and most importantly fast and all in one video!
Incredible. Learned so many functions in just one video. Delivery of the video was simple and informative. Thank you!
@Exceljunction
4 жыл бұрын
Thanks for appreciating
Awesome! The best teacher in Excel ever lived in the planet earth! Thank you so much Teacher. I really understood everything from the beginning of the video til the end of it. Amazing! God Bless you more!!
@Exceljunction
4 жыл бұрын
Thanks for the kind words. Glad, could be of help.
Thank you for a nice tutorial in heavy used excel functions!
Thank you so much for this video! You must be a great teacher! 😊
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
wow !. You really simplified it all for me. Thank You very much
Thank you so much for this video! you must be a great teacher!
@Exceljunction
4 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
You are by far the best teacher I've come across. I was petrified of excel formulas and you made it look believable. Thank you
@Exceljunction
4 жыл бұрын
Thanks for the kind words.
Thank you so much for the understanding on the functions.will come back for more on excel..have an assessment to do
@Exceljunction
5 жыл бұрын
Cheers
thanks for your valuable guidance
@Exceljunction
7 жыл бұрын
+Shirish Shelke Thanks for appreciating Shirish. Do subscribe the channel and share with your friends too. Best Regards
Best way of teaching
very nice way of explaing all necessary formulae in one excel file in a very shrt time..
Thank you for the wonderful lesson, I have learnt something
Thank you for this video which taught basic excel calculation in the most easiest way.
@Exceljunction
4 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
You are a good teacher. Your speed in teaching is just perfect for me to follow and understand . You are the best !!! Keep it up Sir.
@Exceljunction
5 жыл бұрын
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
preparing for my interview tomorrow :^)
@wasimprince4353
5 жыл бұрын
You know i failed in interview bcz i have less knowledge in excel,have u got job
Really nice to see your video. I have learn more now. Thanks so much. Really hope to get more useful functions from your video.
@Exceljunction
5 жыл бұрын
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
This really helps, Thanks!
So effective example, with everything into it.
Thank you for this video!Explained very well and easily to understood :)
@Exceljunction
6 жыл бұрын
+Eziz Karliyev thank you for appreciating. Please spread the good word. Do not forget to subscribe the channel for more useful stuff.
@shyamsundar-xw1vq
6 жыл бұрын
you helps me lot,. thank u so much sir.
Formula's make excel a very powerful tool.
@Exceljunction
6 жыл бұрын
+John D Yes, very much
Hello Sir, So precise! So clear! And to the point! Thank you for sharing. Bless you!
@Exceljunction
3 жыл бұрын
Thanks for appreciating. Please do like the video and subscribe our channel for more such useful videos.
It has been a great lesson....Thanks so much
Thank you very much , it is kind of you to help us understand excel basics properly
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Thank God for the video lectures, I have learnt a lot. I gained confidence in my excel studies.
@Exceljunction
5 жыл бұрын
Thanks for your kind comments. Much appreciated. We'll try to make more such useful videos. Do not forget to subscribe the channel.
Amazing tutorial love this first tym i seen how to use these functions with more easily...
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please do subscribe our channel for more updates.
Very informative! And peaceful voice 👍🙂
Im so bothered by F16 & F17. Can you explain?
well explained...…...thank you sir
@Exceljunction
5 жыл бұрын
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
I need 2,4,6,8...so on rows beside 1,3,5,7....is it posible
HOW CAN WE CALCULATE THE SUM OF 2 COLUMNS WHICH WE NEED TO MULTIPLE THE ROW AND SUM OF COLUMN
Thank you so much It is very very simple method Thank you You did a brilliant job
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
That was so much helpful for most of us.
@Exceljunction
6 жыл бұрын
Glad you found it helpful. Please spread the good word. "Like" and "Subscribe" for more such useful videos.
Loved it...Thank you for posting...Your video is very helpful and easy to understand as well
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
The formulas are a bit tricky but I'm gradually picking up, thanks very much.
Very helpful. Thank you!
it nice and regular useful formulas so thnx sir........to bring essy it for us........
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Please "Like" and "Subscribe" for more such useful tutorials.
what if you have the total and you need to subtract others as you enter and the total column will zero at the end. please help
Very knowledgeable. Thank you.
Thanks very much I enjoyed it
Thanks for your videos in simpler way to understand Excel function.. Please check with avgif and avgifs selection criteria..I didn't understand these two function
@Exceljunction
4 жыл бұрын
Please do not forget to 'subscribe' to our channel for more such useful videos.
i want the main sheet full row come automatically in the other sheet as per the sheet name and the code of the customer.... so is it possible please advise
Thanks so much, this is the most easiest way to learn this formula that has being a problem to me. Thanks once again
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
You are the reason i will get a good grade on my excel test!
@Exceljunction
3 жыл бұрын
Happy if we could be of any help. Wish you all the best for your test 👍
Very informative and easy to understand
THANK YOU! YOU HELPED ME SOOOOO MUCH!
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
absolute lifesaver g, thx
Explained practically by applying each function . Well done Sir. Thanks.
@Exceljunction
Жыл бұрын
You are welcome
Hi mate, could you please tell me, what is the name of the application that you are using to capture screen?
Thanks Sir, the video is simple and clear.
@Exceljunction
5 жыл бұрын
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Whoa,,,, thanks for sharing,,,, GOD bless for your all good works,,,,,
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
I loved this it's awesome and most easy
@Exceljunction
6 жыл бұрын
Great that you liked. Please have a look at other videos too in our channel. You may find them useful too. Do not forget to "subscribe".
Hi, the method of explaining is very fantastic can understand everyone....thank you for this video... very usefull..Thanks....
@Exceljunction
4 жыл бұрын
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
Very helpful. Thanks a lot
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Excellent sir you are great teacher in the worĺd
Excellent Sir. Thanks a lot.
THANK YOU SO MUCHHHHHH!!!!!!
Brilliantly explained. Thanks
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thank you so much. It is simple and excellent.
@Exceljunction
5 жыл бұрын
Thank you for appreciating. It keeps us going. Cheers!!
best teacher
FANTASTIC SIR THANK YOU, SIR, IT WILL HELP ALL
@Exceljunction
6 жыл бұрын
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
thanks for good explanation
@Exceljunction
5 жыл бұрын
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
I know understand better. Thank you very much.
Good information for the beginners. very clear.
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Amazinggggggggggggggggggggg thanks
Which keyboard key do we need to press to select function from drop down after we write = and automatically suggestions pop up ?
you are vary good teacher thanks so much
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please subscribe the channel for more such useful videos.
I have a question, suppose I have a cell (A1) which changes its value every minutes, I want to find the minimum and maximum value of cell A1, every 15 minutes? what is the formula?
@Exceljunction
5 жыл бұрын
Please post your query on our forum www.exceljunction.com/forum/
your explanation is very very ultimate. you explained in a very simple language and a lay man can also easily can understand.. became a big fan of you brother.. vamsi from india
@Exceljunction
Жыл бұрын
Thank you so much for your kind comments 🙏
Sir, It is so educative. Thanks for sharing. I have a query, How to find the list of student names that scored more than 60marks...
Thanks for the great info
@Exceljunction
5 жыл бұрын
Thank you. Do not forget to subscribe our channel for more such useful videos.
this was super helpful
@Exceljunction
5 жыл бұрын
Thank you. Do not forget to subscribe our channel for more such useful videos.
Thanks for teaching me this better that school
@Exceljunction
Жыл бұрын
Happy to help
very helpful and clear. Thnks a ton!
@Exceljunction
3 жыл бұрын
Thanks for appreciating.
Very Nice tutorial, I learned something new from you. Hope you can clarify my doubt Can we count numof cel by filled colors? "Not by the by alphanumerical data".
@Exceljunction
6 жыл бұрын
Please post your query on our forum. www.exceljunction.com/forum/
Excellent! Thank you so much.
@Exceljunction
Жыл бұрын
You're very welcome!
I am not able to get the sum and average by simply dragging the cells downwards, is it because i am using the 2007 version?
this is sooooo good thanks
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please like and subscribe our channel for more useful updates.
Thank you sir it's help in my practical tomorrow
@Exceljunction
3 жыл бұрын
Glad that it helped you. Do subscribe the channel for more such useful videos.
Excellent ji...thank you so..much....
@Exceljunction
6 жыл бұрын
+arunthejeanious Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thank you!
Thanks it is useful nice sir..keep teaching
Thanks so very much Sir
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Thanks for the video
Thanks
I'm in trouble with my table. I can't tell it here. How can i contact you
@Exceljunction
6 жыл бұрын
Please post your query on our WhatsApp group.
VERY GOOD... AND WELL EXPLAINED
@Exceljunction
5 жыл бұрын
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Simply super sir, thank you so much sir
@Exceljunction
3 жыл бұрын
Thanks for appreciating.