How to Use SUMPRODUCT in Excel

  Рет қаралды 725,626

Leila Gharani

Leila Gharani

8 жыл бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Quickly learn how Excel's SUMPRODUCT function works. It is one of Microsoft Excel's most powerful yet often overlooked function.
⬇️ Download the workbook: pages.xelplus.com/sumproduct-...
🔑 Key Highlights:
▪️ Start with basic SUMPRODUCT uses - perfect for those new to Excel.
▪️ Advanced Applications: See how SUMPRODUCT can replace complex functions like VLOOKUP and SUMIFS.
▪️ Real-World Examples: From calculating revenue to performing OR conditions, learn through practical scenarios.
▪️ Pro Tips: Crucial syntax tips for error-free usage.
The classical use of Excel's SUMPRODUCT function is to do a sum of multiplications. The good thing about SUMPRODUCT is that it can work on arrays of values and it doesn’t have to be entered as an array function so no need to do control + shift + enter (CSE).
The great thing about SUMPRODUCT, is that it can help solve many more problems in non-obvious ways. It can act as a conditional SUMIFS function or work as a lookup function as INDEX and MATCH does. It can also act as a COUNTIF function.
SUMPRODUCT is also a better SUMIFS, because it can check for OR conditions - which the SUMIFS can't. SUMIFS can only check for AND conditions.
In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you from unnecessary "workarounds" in your Excel files. It will also show you the SUMPRODUCT formula in slow motion.
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 737
@LeilaGharani
@LeilaGharani 5 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/sumproduct-file
@jimbarton7072
@jimbarton7072 5 жыл бұрын
One of your very best videos! Not only did I learn something about SUMPRODUCT, but your "slow motion" explanation is elegant and understandable. I try something similar when teaching SUMIFS, but you've really clarified it.
@CheerfulMillie
@CheerfulMillie 5 жыл бұрын
Super clear demonstration. Short and precise. Thank you!
@excelymasoficial
@excelymasoficial 7 жыл бұрын
EXCELlent!!! Thank you Leila!
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you +Otto Javier. You have Excellent videos yourself! Great quality! Very impressive. Are they all in Spanish?
@excelymasoficial
@excelymasoficial 7 жыл бұрын
Thanks for your appreciation. Yes, they are all in Spanish. I have seriously considered putting subtitles to each of them. :) Best regards!
@rauljimenez5485
@rauljimenez5485 5 жыл бұрын
The simplicity and elegance of this use of sumproduct is genious, you rock!! 😀
@williamarthur4801
@williamarthur4801 2 жыл бұрын
I've always loved Sumproduct, it does so much; and nice to hear / see someone emphasizing the importance of bracketing, I ended up creating a crib sheet of every AND / OR combination I could think as I was always getting confused. Still do for that matter.
@johnsonbolhayon4790
@johnsonbolhayon4790 5 жыл бұрын
Wow..... Just wow! This helps a lot with my excel problems. Still watching a lot of your contents and they are all very helpful since you're so good at explaining the concept really well. You have an exceptional/genius skills in excel! I'll watch them all and proceed with your VBA next. 😉
@smithanimal
@smithanimal 4 жыл бұрын
I can't believe how helpful this video was. As someone somewhat advanced in Excel the concept of SUMPRODUCT's utility has always somewhat evaded me. This video was laid out in such a perfect and simple format I completely grasp how the command is actually calculating now. I'm going to turn to your channel for any excel help. Nicely done!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
I‘m very glad to hear that Corey! Thank you.
@shaolinmaster6362
@shaolinmaster6362 3 жыл бұрын
I love Leila!!! My favorite excel teacher!! I recommend her to everyone who wishes to expand their knowledge about any aspect of this tool!!!
@snicho
@snicho 5 жыл бұрын
This just became my favourite explanation of the SUMPRODUCT function! All of the blog posts about SUMPRODUCT that I had previously bookmarked are now redundant. Great job Leila!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you! I'm glad to hear that snicho :)
@lpanebr
@lpanebr 5 жыл бұрын
This is awesome. Everytime I think "oh, I already know about this function" I'm wrong, because there is always something new to learn with your videos. Thank you!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
It happens to me all the time :)
@tamilarasans3737
@tamilarasans3737 Жыл бұрын
Your videos are amazing, i have a doubt regarding if lot of datas are there with respect to date...for example for 20 years .how to get month average of every month without using match or lookup or any cell reference formula.
@garyshorn
@garyshorn 3 жыл бұрын
This was a wonderful tutorial. Had been doing vlookup with multiple "ifs" till now. This was amazing.
@ImHewg
@ImHewg 8 жыл бұрын
Hey great video, the way you throughly explain everything amazing and made it easy to understand exactly how it all works. Thank you so much!
@Asgardskasvinucha
@Asgardskasvinucha 4 жыл бұрын
Thank you Leila, I didn't know this great potential of this function before I watched this video. Today, inspired by your video, I used it in another way than usually (combined with "left()") and worked great 🙂
@avinashbaswante7186
@avinashbaswante7186 5 жыл бұрын
Your Lectures are really helpful M'am, Thank you!!
@anhkimnguyen2223
@anhkimnguyen2223 4 жыл бұрын
You explained this so articulately, made it really easy to understand. Thank you so much!
@mahatarek2982
@mahatarek2982 5 жыл бұрын
the easiest and clearest explanation, many thanks, wish you always the best. please keep it up
@jackfrost1031
@jackfrost1031 6 жыл бұрын
Another great video. This sort of formula is really elegant. It makes multi condition statements so much easier and takes very few helper cells.
@anonanon9823
@anonanon9823 5 жыл бұрын
Thank you for creating such useful content! I always make sure to revisit them so that I don't forget anything!
@Jenicek25
@Jenicek25 5 жыл бұрын
Your videos are so great - clear, meaningful examples, usefult tips. Thanks very much!!
@MrZamuhammed
@MrZamuhammed 5 жыл бұрын
Great......Leila..,really helpful and extraordinary explanations......very very thanks.
@mithunghosh2767
@mithunghosh2767 5 жыл бұрын
Hi Leila - thanks a ton for your videos. They have been really helpful
@jochbo
@jochbo 5 жыл бұрын
Thanks Leila for showing us the + and * trick when doing OR and AND!
@hodazadeh4745
@hodazadeh4745 5 жыл бұрын
These tips made my life much easier. Thanks Leila
@williamedgarperrigo9813
@williamedgarperrigo9813 3 жыл бұрын
i’ve worked with sumproduct but this segment cleared up unanswered questions. Thank you!
@kapilprasannaa
@kapilprasannaa 5 жыл бұрын
This helped me so much in my Excel interview today. I used sumproduct instead of countifs and sumifs and the interviewer was visibly impressed. Thank you so much - you will have a lot of good karma (and business) for doing this.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm glad it was helpful!
@horvathgabor5485
@horvathgabor5485 4 жыл бұрын
@@LeilaGharani Wow... I'm very courious of it... what kind of task could it have been where I use sumproduct instead of countifs and sumifs? Could you or maybe Kapil P please give an example?
@horvathgabor5485
@horvathgabor5485 4 жыл бұрын
Meanwhile I studied "sumproduct", now I know that it can be used as countif (count quantity, as in this video, no numbers will be counted) and sumif (when there is only 1 array, so there's no multiplicaton)
@TruthofDilly
@TruthofDilly 4 жыл бұрын
​@@LeilaGharani there any way I can add up a certain product in a list of many different items?
@robertofelce
@robertofelce 3 жыл бұрын
The hot tip for the + meaning or, blew my mind. Didn't know about it. Thank you so much!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
You are so welcome, Roberto!
@lmcbunnylove
@lmcbunnylove 6 жыл бұрын
Thank you so much! It was immensely helpful!
@ketanshah3736
@ketanshah3736 3 жыл бұрын
Great explanation. It helped me in creating very useful calculations. Thanks.
@yaashjut76
@yaashjut76 5 жыл бұрын
that is really fantastic. thank you Leila for teaching another useful lesson
@chicagomike
@chicagomike 4 жыл бұрын
One of the best teachers on the internet. Bravo.
@petemurphy7164
@petemurphy7164 4 жыл бұрын
Yeah, I agree, I even have done a few of her courses online through Udemy. At my work now I am now considered a bit of an Excel Guru... These videos have really helped.
@sunnyn9017
@sunnyn9017 4 жыл бұрын
Hello!! This is an amazing channel! I used Sumifs, index match mainly but not Sum product. I knew more than most in both organisations over the past decade but, this is a game changer! Thank you so much!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad it's helpful for you. Sumproduct really can be quite useful.
@jackychawla5422
@jackychawla5422 7 жыл бұрын
superb explanations i found 2nd best tutorial ever on youtube that makes u matchless!!!!!!!!!!!!!!!!! mam could u please make a video on lookupformulas beginner to advance
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Hi Jacky. That is so flattering!! Thank you! I have a video on VLOOKUP & HLOOKUP. I'll try to get it loaded before the weekend.
@jadoabad
@jadoabad 7 жыл бұрын
Is the 1st best tutorial also about Excel? If so, would appreciate if you let me know what it is.
@zoutube19
@zoutube19 5 жыл бұрын
What a great video, I think you've just saved me a lot of time. Thanks!!
@tarat700
@tarat700 5 жыл бұрын
FINALLY, someone who explains this in a way that makes sense! Thank you.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
You're very welcome. I'm glad it makes sense :)
@BiancaAguglia
@BiancaAguglia 5 жыл бұрын
Brilliant teaching style, Leila. Your work ethic and the quality of your presentations are inspiring. Thank you for posting these tutorials.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you Bianca! I'm glad you find the tutorials useful.
@DouDouMa
@DouDouMa 7 жыл бұрын
I have been using excel for work for quite sometime. Have been searching what function can perform both sumif & sumproduct at the same time. Finally, found this video! This is the most powerful function I have learnt in Excel so far! The tutorial had explained the function very clearly that make very easy to understand & apply! Also found that besides "+", can also use "-" to exclude some conditions. Thanks a lot!
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're very welcome. Glad you liked the explanation. True. SUMPRODUCT is so versatile by itself and on top it can be combined with other functions to create impressive one formula arrays.
@charlesochan9892
@charlesochan9892 4 жыл бұрын
Leila Thank you so much and God bless you for these wonderful tutorials that have transformed me.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
My pleasure Charles. I'm glad you find the tutorials helpful.
@choychaby4386
@choychaby4386 5 жыл бұрын
All I can say is thank you! Superb!
@RiteshPatelSEOExpertAhmedabad
@RiteshPatelSEOExpertAhmedabad 7 жыл бұрын
Your explanation of excel formula's are outstanding.
@y7iia
@y7iia 5 жыл бұрын
It is really amaizing that, this video is free !!. Excellent work Leila. Sumproduct is really an amaizing and extreemly usefull function
@kamelgameel1250
@kamelgameel1250 5 жыл бұрын
Great lecture, This is totally useful thanks Leila
@EricaDyson
@EricaDyson 5 жыл бұрын
I know this is an old session but it's new to me and I'm so glad I found it! Thanks so much. So clear, so useful!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Oldies are goldies :) Glad you found it useful Erica.
@ulisesserna6155
@ulisesserna6155 5 жыл бұрын
Leila great job, helping me grow my knowledge.... looking forward to keep learning from you.
@merissawong1883
@merissawong1883 5 жыл бұрын
I finally understand sumproduct. Thank you! Could you provide a video on how to incorporate multiple named ranges as the criteria in sumproduct?
@yasseralg3928
@yasseralg3928 3 жыл бұрын
Very well executed explanations! Thank you 😊
@ivanrybalchenko7225
@ivanrybalchenko7225 4 жыл бұрын
Thank you! Your explanation is so clear.
@rheymanda1074
@rheymanda1074 4 жыл бұрын
Your tutorials are the best. Thank you for sharing this knowledge. This is a fantastic use of this function and I can't wait to see how I'll be using it.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad you find the tutorials helpful Guillaume.
@dasrotrad
@dasrotrad 6 жыл бұрын
EXCELLENT explanation. You do a marvelous job explaining a complex function. Thank you!
@LeilaGharani
@LeilaGharani 6 жыл бұрын
You're welcome Robert. Glad you like the explanation.
@isaiahmaragalla
@isaiahmaragalla 3 жыл бұрын
you are amazing. thank you. such a clear explanation. hot tip of true value as 1 and false value as 0 is brilliant
@hadibq
@hadibq 2 жыл бұрын
Great demo for this great function! the array aspect of it now got a bit forgotten by old-timers with all the new array native functions. TY
@MrVikas28feb
@MrVikas28feb 7 жыл бұрын
Thank you Leila. Your videos are much appreciated.
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're welcome. Glad to hear that.
@frankie3005
@frankie3005 5 жыл бұрын
Superb. Without a doubt, you're excel guru. Someone called me yesterday guru because I made for them a simple software. But you're the real guru you're teaching billions of people around the world.
@mtsplacement
@mtsplacement 5 жыл бұрын
Very useful formula and you explained it very well :), Thank You
@Tat-cx1lr
@Tat-cx1lr 6 жыл бұрын
Merci. Avec vous on est sûr s’apprendre quelque chose à la fin de la vidéo. Amicalement.
@innerfire81
@innerfire81 5 жыл бұрын
Fantastically helpful video! Thank you!
@normanli2943
@normanli2943 5 жыл бұрын
Very clearly explained! Thank you Leila, you are a good teacher!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm glad you like it!
@surabhijagadish5210
@surabhijagadish5210 7 ай бұрын
Easy way of teaching complex formulas. Appreciate your hard work❤.
@sasavienne
@sasavienne 5 жыл бұрын
I am very grateful to you Leila, you really opened my eyes to learn something truly nice and useful and absolutely helpful. You are more than amazing. I like your videos so much.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm really glad it is helpful!
@markbowker3283
@markbowker3283 Жыл бұрын
Your videos are so clear and concise. Thank you so much for all the help you have provided me.
@LeilaGharani
@LeilaGharani Жыл бұрын
Thank you for the kind feedback, Mark!
@lavitaneja4161
@lavitaneja4161 7 жыл бұрын
BEAUTIFUL WAY OF TEACHING, Thank you so much.
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you Lavi.
@nageshkaria6190
@nageshkaria6190 Жыл бұрын
your teaching methods is very easy and effective. thank you so much for that
@mohamedtharwat1233
@mohamedtharwat1233 4 жыл бұрын
Priceless illustration! It`s hard to find words to express my appreciation
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Thank you for the kind feedback!
@infernaltactics4498
@infernaltactics4498 Жыл бұрын
thank you so much, this is the exact video I needed to make my sumproduct formula work :)
@operamaniak81
@operamaniak81 3 ай бұрын
Many new functions in Excel, but this video is like about a new star too. Very inspiring, thank you!
@MsRainbow1983
@MsRainbow1983 3 жыл бұрын
Amazing! What a great, easy to follow tutorial!
@tetianazakharenko2731
@tetianazakharenko2731 10 ай бұрын
each time I see your video I know I'm going to be surprised. This one is not an exception. Thank you for sharing.
@sachinrv1
@sachinrv1 6 жыл бұрын
Leila, thanks for sharing this exquisite function. Usually we tend to use countif/s, sumif/s for they are quite a simpler than sumproduct. The slight rigidity of sumproduct is in understanding use of "*" ,"+" and "=". This will take a person little while to get hang on to. But still surely useful. Thanks again...
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Yes, true - we have to be careful with the brackets too when using SUMPRODUCT. But the great thing about it, is it can simply do OR conditions which the SUMIFS can't do easily - (unless we use two or more SUMIFS functions or wrap the SUMIFS inside a SUMPRODUCT function :) )
@cocococo7089
@cocococo7089 4 жыл бұрын
Thank you very much Leila for teaching us Excel functions. Can you kindly do a session on how to use Excel cubes?
@epistleepitome
@epistleepitome 5 жыл бұрын
Crisp n clear explanation
@nesarahmad2121
@nesarahmad2121 3 жыл бұрын
Super clear and simple. Wow.....
@nour-eddineoumakhlouf5296
@nour-eddineoumakhlouf5296 3 жыл бұрын
Always coming with something New! Bravo!
@willyrodrigo9375
@willyrodrigo9375 3 жыл бұрын
Best Excel Lectures ever!!
@tanguerochas
@tanguerochas 6 жыл бұрын
Very helpful. Thank you. I just signed up for two more of your courses on the basis of what I've seen here. I am sure they will be worth it.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
You're very welcome. Thank you for your support of my courses. Hope you find a lot of value in them for your work.
@amritdural1127
@amritdural1127 2 жыл бұрын
@Leila is the Goddess of Excel...this video had answers to lot of my queries...thank you..u are the best
@NoShadowOfDoubt1
@NoShadowOfDoubt1 4 жыл бұрын
Thank you... a great alternative to two SUMIFs....
@MichaelCamacho-uf5wv
@MichaelCamacho-uf5wv 6 ай бұрын
Great explination of how Excel interprets the information.
@biohazard737
@biohazard737 5 жыл бұрын
i stumbled into your videos while bored at work. i love your explanations, great work! now i have to watch all your videos and pick up all the cool tricks!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you! I'm glad to hear that :)
@ah244895
@ah244895 5 жыл бұрын
You are great at explaining. I learned much of this already but you explain how and why it works superbly!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you! I'm glad you find the tutorials easy to follow :)
@animeasia6450
@animeasia6450 Жыл бұрын
Wow this video actually clears all my doubts thank you ma'am.
@debseymour5705
@debseymour5705 2 жыл бұрын
Wow Leila This saves me so much time. Thanks Heaps!!
@resrussia
@resrussia 7 жыл бұрын
Excellent video tutorial on SUMPRODUCT. Your explanations are easy follow.
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thanks +Training Research
@darcyg852
@darcyg852 3 жыл бұрын
Best instructor! Bar none! You make it so comprehensive!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Wow, thank you Darcy!
@shironmania
@shironmania 5 жыл бұрын
Rightly said that this is for advanced users....many would have used sumproduct in a elementary level but with criteria it makes a very useful tool....thanks again
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Very true. It really is a powerful function that is often overlooked.
@EliotPowell
@EliotPowell 4 жыл бұрын
First, I have only recently discovered your KZbin channel, and I find it to be super helpful, and secondly, your explanation and uses for SUMPRODUCT will absolutely change the way I use Excel. A few comments: 1. Typos in the SUMPRODUCT_Excel_Explained_Free_Worknook_Xelplus: in Cells H23, H24 and H25 the word is SUMPRODUCT (not “SUMPRODCUT”) 2. In practicality, I find the Average Price calculation misleading. Revenue of 98,200 divided by a quantity of 470 units is 208.94. Your calculation of 208.40 is effectively a simple average of the 5 prices, not reflective of how much was sold. 3. Curiously, when you double check the Average Price (around 13:45 of the video), the Status Bar shows an average value for the highlighted values in cells D46, D47, D48, D50 and D52 of 208. I get the same result of 208 when highlighting the numbers in the same sequence (D46, D47, D48, D50, then D52) 4. The numbers in those cells (100, 200, 320, 222, and 200) actually have an average of 208.4. Somehow, the Status Bar shows a different (incorrect?) number of 208. 5. Even more curious, on my computer, when I highlight the cells from your file in reverse order (D52, D50, D48, D47, then D46) the Status Bar shows the correct Average Price of 208.4 … I don’t know why this is, but I am hoping you can explain it!
@ketandave3273
@ketandave3273 3 жыл бұрын
LG! This was really good. I never knew this! It makes match-index complications hell of a simple thing! Thank you very much.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad to help :)
@zainulabdin3504
@zainulabdin3504 7 жыл бұрын
Leila Gharani, I found your videos great and helpful. You are doing a great work. Your mode of delivering information and your presentation is best of best. Slowly and steadily you focus on each and every point and make lecture complete. May God reward you for this kind work. Wish you success. Thanks
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you so much for your comment! Makes me very happy to hear you find the videos helpful.
@ricardoluizmarcello
@ricardoluizmarcello Жыл бұрын
I’m impressed with your knowledge
@bebugerbebuger8617
@bebugerbebuger8617 3 жыл бұрын
That's how Excel (and everything) should be taught. Thank you
@tedsterrett7204
@tedsterrett7204 3 жыл бұрын
You're amazing! thank you for the knowledge.
@lh6273
@lh6273 7 жыл бұрын
Thank you. You are the best, by far. Regards from El Salvador. 🙂
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're welcome Luis....and thank you!
@Lamouettekamikaze
@Lamouettekamikaze 4 жыл бұрын
Exactly what I was looking for !
@user-li7mq5hp9g
@user-li7mq5hp9g 3 жыл бұрын
Perfect explanation as always!
@wwiii469
@wwiii469 3 жыл бұрын
really helpful crystal clear i have watched so many tutorials this one work for me
@nithiniloveu
@nithiniloveu 4 жыл бұрын
Wow just awestruck by your materials and explanations of concepts. Thanks a ton.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
You're very welcome. Glad you find the tutorials helpful.
@robertotorres4115
@robertotorres4115 2 жыл бұрын
Thanks a lot for your videos! They all are super useful!
@user-ff4lt3bo7i
@user-ff4lt3bo7i 4 жыл бұрын
Thank you for the tutor! Very Helpful!
@TJMelrose
@TJMelrose 4 жыл бұрын
I wish I could give this video 1000 thumbs-up. I finally understand SUMPRODUCT well enough to use it on my own. Thank you Leila Gharani!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
I'm already happy with the one thumbs up :) I'm glad the video is helpful Thomas.
@pavannandula
@pavannandula 4 жыл бұрын
Awesome video. Now I got to know about the real use & value of SumProduct Function
@clarehumail
@clarehumail 6 жыл бұрын
How fantastic your interdiction for SUMPRODUCT formula. It is useful for me, Thank you Leila.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
I'm happy to hear you find it useful. Thank you for the feedback.
Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM
13:15
Leila Gharani
Рет қаралды 196 М.
A pack of chips with a surprise 🤣😍❤️ #demariki
00:14
Demariki
Рет қаралды 44 МЛН
Climbing to 18M Subscribers 🎉
00:32
Matt Larose
Рет қаралды 33 МЛН
1 класс vs 11 класс  (игрушка)
00:30
БЕРТ
Рет қаралды 4,1 МЛН
La revancha 😱
00:55
Juan De Dios Pantoja 2
Рет қаралды 68 МЛН
Why Pro Excel Users Love SUMPRODUCT!
8:08
MyOnlineTrainingHub
Рет қаралды 56 М.
How to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel (Multiple Criteria)
14:04
Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria
10:22
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 439 М.
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 367 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 69 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 293 М.
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
13:34
Leila Gharani
Рет қаралды 3,5 МЛН
How to use Excel Index Match (the right way)
11:32
Leila Gharani
Рет қаралды 3,6 МЛН
A pack of chips with a surprise 🤣😍❤️ #demariki
00:14
Demariki
Рет қаралды 44 МЛН