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

[@manojkumar-gk6dd]

This is explained in such a simple manner, thank you, sir ............

[@nabrii1924]

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.

[@user-mg2lf9mx7r]

Thanks a lot , you are one of the best teachers in the world of Excel!

[@Exceljunction]

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.

[@how-2116]

You are good teacher, thank you for this video.

[@usama273]

First time i saw the most easiest way to use IF formulas thats awesome

[@Exceljunction]

Thanks for appreciating Moeez. Do subscribe the channel and share with your friends too. Best Regards

[@eleanorsummer8320]

This is explained in such a simple manner, thankyou so much.

[@Exceljunction]

Thanks for appreciating.

[@akinyetunpraise6742]

I'm in trouble with my table. I can't tell it here. How can i contact you

[@Exceljunction]

Please post your query on our WhatsApp group www.exceljunction.com/whatsapp-group/

[@KiranKumar-kc5tw]

Just going for an interview and had a look over it and now im clear about the functions. Thank you sooo much sir.

[@SaiTeja0805]

Which company you are working?

[@hussainabbas2024]

perfect! I did not understand a thing when our teacher taught us. Thanks for video need more of them and subscribing you

[@Exceljunction]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@soumyashreebiswal14]

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]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@tdm5927]

You did an excellent job explaining how each one works!! Love it!!

[@Exceljunction]

+TT Matt Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@filiproh2625]

Awesome! Easy and most importantly fast and all in one video!

[@iscoalmichael3117]

Thanks for the terrific job, it solves almost all of my daunting task.

[@sarahc.1956]

Incredible. Learned so many functions in just one video. Delivery of the video was simple and informative. Thank you!

[@Exceljunction]

Thanks for appreciating

[@muhammadyaqoob1869]

Best way of teaching

[@stephanie03]

Thank you so much for this video! You must be a great teacher! 😊

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@shewalemabedla8452]

Thank you so much for this video! you must be a great teacher!

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@mudassarnadeem4084]

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

[@pensymorin5042]

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]

Thanks for the kind words. Glad, could be of help.

[@roosterr66]

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]

Thanks for the kind words.

[@Sjongleringsmannen]

Thank you for a nice tutorial in heavy used excel functions!

[@kofibamfo6401]

wow !. You really simplified it all for me. Thank You very much

[@tonysalinas5903]

This really helps, Thanks!

[@nasirmuhammad3901]

Thank you for this video which taught basic excel calculation in the most easiest way.

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@09shirish]

thanks for your valuable guidance

[@Exceljunction]

+Shirish Shelke Thanks for appreciating Shirish. Do subscribe the channel and share with your friends too. Best Regards

[@johnd6575]

Formula's make excel a very powerful tool.

[@Exceljunction]

+John D Yes, very much

[@minnieescarilla8842]

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]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@thegirlinquestion]

preparing for my interview tomorrow :^)

[@wasimprince4353]

You know i failed in interview bcz i have less knowledge in excel,have u got job

[@mhmedia6710]

Thank you for the wonderful lesson, I have learnt something

[@raviwadhwa1815]

So effective example, with everything into it.

[@happyfamilylifescreations]

Thank you so much for the understanding on the functions.will come back for more on excel..have an assessment to do

[@Exceljunction]

Cheers

[@aniki7232]

That was so much helpful for most of us.

[@Exceljunction]

Glad you found it helpful. Please spread the good word. "Like" and "Subscribe" for more such useful videos.

[@Ayushgaming-bj1rl]

Excellent sir you are great teacher in the worĺd

[@ezizkarliyev2833]

Thank you for this video!Explained very well and easily to understood :)

[@Exceljunction]

+Eziz Karliyev thank you for appreciating. Please spread the good word. Do not forget to subscribe the channel for more useful stuff.

[@shyamsundar-xw1vq]

you helps me lot,. thank u so much sir.

[@javedaslam8274]

very nice way of explaing all necessary formulae in one excel file in a very shrt time..

[@PhanithReach]

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]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@patrickbaysahwala33]

The formulas are a bit tricky but I'm gradually picking up, thanks very much.

[@nabrii1924]

Thank God for the video lectures, I have learnt a lot. I gained confidence in my excel studies.

[@Exceljunction]

Thanks for your kind comments. Much appreciated. We'll try to make more such useful videos. Do not forget to subscribe the channel.

[@shero2794]

Thanks for teaching me this better that school

[@Exceljunction]

Happy to help

[@lubyayicharles3305]

It has been a great lesson....Thanks so much

[@ezzahmed7080]

Hello Sir, So precise! So clear! And to the point! Thank you for sharing. Bless you!

[@Exceljunction]

Thanks for appreciating. Please do like the video and subscribe our channel for more such useful videos.

[@Iksi_]

You are the reason i will get a good grade on my excel test!

[@Exceljunction]

Happy if we could be of any help. Wish you all the best for your test 👍

[@rasithdias1584]

absolute lifesaver g, thx

[@ismailallychakachene652]

Thank you very much , it is kind of you to help us understand excel basics properly

[@Exceljunction]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@HeartlanderArt]

Very helpful. Thank you!

[@Andrew_Jordaan]

THANK YOU! YOU HELPED ME SOOOOO MUCH!

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@loganathanr238]

Amazing tutorial love this first tym i seen how to use these functions with more easily...

[@Exceljunction]

Thanks for appreciating. Please do subscribe our channel for more updates.

[@secretaryalghurair8104]

Thanks so much, this is the most easiest way to learn this formula that has being a problem to me. Thanks once again

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@tastycuppa2851]

Thank you so much
It is very very simple method
Thank you
You did a brilliant job

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@SushmitNaik]

Very informative! And peaceful voice 👍🙂

[@ketn0o416]

THANK YOU SO MUCHHHHHH!!!!!!

[@vidyanair9432]

Explained practically by applying each function . Well done Sir. Thanks.

[@Exceljunction]

You are welcome

[@faithjeroben8786]

well explained...…...thank you sir

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@karvintin09]

Very knowledgeable. Thank you.

[@mittujose2741]

Very informative and easy to understand

[@veronicafahnbulleh4323]

Thanks very much I enjoyed it

[@taniakhatun7642]

I loved this it's awesome and most easy

[@Exceljunction]

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".

[@thaimalabar5755]

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

[@kelvyngonsalves8829]

Amazinggggggggggggggggggggg thanks

[@nurasahardid4641]

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

[@trustinwwjd1997]

Whoa,,,, thanks for sharing,,,, GOD bless for your all good works,,,,,

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@wihazet1185]

Hi mate, could you please tell me, what is the name of the application that you are using to capture screen?

[@dcpssaiha5415]

Loved it...Thank you for posting...Your video is very helpful and easy to understand as well

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@pravinkarade2280]

it nice and regular useful formulas so thnx sir........to bring essy it for us........

[@Exceljunction]

Thanks for appreciating. Please "Like" and "Subscribe" for more such useful tutorials.

[@adenikeolatunde5333]

Very helpful. Thanks a lot

[@Exceljunction]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@leetwigg]

Brilliantly explained. Thanks

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@mohammednowfer8732]

Hi, the method of explaining is very fantastic can understand everyone....thank you for this video... very usefull..Thanks....

[@Exceljunction]

Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.

[@annantja1]

best teacher

[@RajSiv]

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]

Please do not forget to 'subscribe' to our channel for more such useful videos.

[@fukiaatechnology9192]

Excellent Sir. Thanks a lot.

[@georgerobingeorge]

HOW CAN WE CALCULATE THE SUM OF 2 COLUMNS WHICH WE NEED TO MULTIPLE THE ROW AND SUM OF COLUMN

[@user-ne1vl8vz1n]

Thanks for the video

[@uchenwogo2544]

Thanks Sir, the video is simple and clear.

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@shepal7306]

Excellent! Thank you so much.

[@Exceljunction]

You're very welcome!

[@deepab5259]

Thank you so much. It is simple and excellent.

[@Exceljunction]

Thank you for appreciating. It keeps us going. Cheers!!

[@ishaaggarwal4305]

Which keyboard key do we need to press to select function from drop down after we write = and automatically suggestions pop up ?

[@aliyarhusain8276]

FANTASTIC SIR THANK YOU, SIR, IT WILL HELP ALL

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@cmavamsikrishna2173]

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 🙏

[@syedarshadahmed4626]

very helpful and clear. Thnks a ton!

[@Exceljunction]

Thanks for appreciating.

[@jeffersonumara2371]

this was super helpful

[@Exceljunction]

Thank you. Do not forget to subscribe our channel for more such useful videos.

[@lemoganginnocentia1542]

I know understand better. Thank you very much.

[@terrencemadanhi8833]

thanks for good explanation

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@SuneelKumar-de8yn]

I need 2,4,6,8...so on rows beside 1,3,5,7....is it posible

[@nimrodsiluyele9676]

Good information for the beginners. very clear.

[@Exceljunction]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@tajammulhussainKhadir]

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]

Please post your query on our forum. www.exceljunction.com/forum/

[@jerelnaito5975]

Thank you!

[@jackpanther1889]

Thanks for the great info

[@Exceljunction]

Thank you. Do not forget to subscribe our channel for more such useful videos.

[@ru2285]

this is sooooo good thanks

[@Exceljunction]

Thanks for appreciating. Please like and subscribe our channel for more useful updates.

[@lavendersusan4115]

Wow. Awesome teaching

[@Exceljunction]

Glad you liked it

[@giribv1691]

Thanks

[@reyaden6049]

Im so bothered by F16 & F17. Can you explain?

[@janral593]

you are vary good teacher thanks so much

[@Exceljunction]

Thanks for appreciating. Please subscribe the channel for more such useful videos.

[@paulashford4155]

love this

[@elenamoon4291]

Great!

[@Exceljunction]

+Elena Moon Thanks for appreciating. Do not forget to "like" and "subscribe" the channel.

[@davindaniellaofficialtv7466]

Thanks it is useful nice sir..keep teaching

[@jagathkumar6425]

Thank you, Very well explained

[@Exceljunction]

+Jagath Kumar Many thanks for appreciating. Please "like" and do not forget to "subscribe" the channel.

[@krishnachaitanya5515]

Simply super sir, thank you so much sir

[@Exceljunction]

Thanks for appreciating.

[@skvish101]

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]

Please post your query on our forum
www.exceljunction.com/forum/

[@MrSEYHA007]

អរគុណអ្នកសម្រាប់មេរៀនដ៏ល្អមួយនេះ

[@Exceljunction]

+Seyha Vann please post in English. We could not figure out what you're trying to say.

[@MrSEYHA007]

oh my got. i just wrote in Khmer to say thank you for sharing a very useful lesson on this excel function. Thank you again for caring about this. excellent!

[@Exceljunction]

+Seyha Vann Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@srikanth7368]

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...

[@jelajahsebanten]

Good sharing, my brother👍👍