Grab the file I used in the video from here 👉 pages.xelplus.com/sumifs-multiple-criteria
@kvanniekerk3792
3 жыл бұрын
I am always drawn back to this channel after watching other people provide tutorials on excel. Your teaching style is easy to follow yet informative. I appreciate that you are confident in the message you are getting across and that you always include small details like Ctrl + Backspace to return to the top of the column after making a selection. So many other instructors trying similar things in Excel on YT don't even use such simple shortcut tips, and that instantly puts me off as I lose confidence in what they are trying to achieve from the outset.
@ksdinkins
6 ай бұрын
Leila, you are a lifesaver! I was having trouble completing my course assignments. Thank you for making your videos easy to follow and understand! With your assistance, I am on my way to an "A"!
@martyc5674
3 жыл бұрын
Great Video again Leila - I needed this recently, however my criteria were not in adjacent cells so passing the range to SUMIFs was not an option.. instead I ended up with something like this =SUM(SUMIFS(J:J,C:C,M:M,{"Asia","Europe"})) works perfect and gets around the Zero issue aswell, albeit you have to maintain the array within the formula.
@YQong
3 жыл бұрын
Thank you, Mr.Martin
@yuriestevezalonso3170
2 жыл бұрын
this comment right here is exactly what I needed. Thanks a lot Martin!
@hussainprintingpress3394
Жыл бұрын
great work but not working in google sheets :(
@chiawoanting8483
Жыл бұрын
THANK YOU!
@narinderkumar7831
Жыл бұрын
I almost checked 20 videos for 2 two days, could not find addition of two condition using same column, found only in your video. & in very simple english with no slangs. big big thanks.
@prof.code-dude2750
3 жыл бұрын
Unbelievable you read my mind! 🔥 I wanted to do this for my school project and you made a tutorial. I really like this as it will help in multiple entries for like a booking spreadsheet where one person books more than one ticket, so to calculate total price i need this! Please keep up your insane talent and you will reach 10M in no time 👍👍🙏🙏🔥🔥😀😀
@JoshColletta
3 жыл бұрын
I've been working with this function a LOT over the past couple of days (putting together a sports statistics file for broadcast graphics), and I felt like i just BARELY had a grasp on it. You've clarified quite a bit for me! Thanks!
@chrism9037
3 жыл бұрын
This was totally awesome Leila!!
@bendreessen2809
8 ай бұрын
Fantastic! This video is easy to understand, provides insights others have missed, and has cut down my formula by 90%. Thank you for the great content!!
@LeilaGharani
8 ай бұрын
Great to hear!
@NetDijk
2 жыл бұрын
Exactly what I was looking for and couldn't find in the go to Excel forums, while this is such a commons information need. One remark (perhaps good to mention) is that I do not use the American notations, but European. So the formula will use semi colums for instance.
@ankushthukral10
17 күн бұрын
very prcise use of formula and very good example. really helpful. thanks
@paulradon
3 жыл бұрын
You made my life easier. Thank you!!!
@andrewdutch4843
2 жыл бұрын
Brilliant video... Thanks!! What can I do if my dataset has spaces or blanks in some of the columns??
@e.a.dequilla1529
2 жыл бұрын
Thnks for this video, i was able to finish the assignment given by our instructor. helpful tip for those who are struggling on how to calculate using two conditions.
@dilipraghuvanshi7331
Жыл бұрын
Hey Leila, Thanks a million for putting such robust tutorial about excel.❣❣❣ I'm seriously appreciate your genuine efforts and time you take for each videos. I got really great command on excel.❣❣ I have complex problem for you regarding sumif (). I have created stock report. Now, I using dropdown list for "Opening balance", "Inward", "Outward" and "closing balance" in column and put values separately in different columns for all three options. Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day. My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock". And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock". This huge problem, I'm facing now. Please give solution.🙏🙏🙏🙏🙏🙏
@IshaMalikOnGoogle
3 жыл бұрын
Leila has anyone told you - "you are amazing awesome perfect" just because of your youtube videos I have grown from 'Zero to Hero'.., soon going to enroll for your course on xelplus can't wait to be a champion in Excel
@vivekphadke16
3 жыл бұрын
A very smart solution, I was doing it a hard way (now I can only laugh at myself) Thanks Leila.
@markpodesta4605
3 жыл бұрын
Thank you Leila. You know your Excel stuff.
@alexrosen8762
3 жыл бұрын
You saved my day today at work with your formula solution. Thanks Leila!
@dimzer5594
2 жыл бұрын
The best Excel tutorials online!! Thank you and keep going!
@WYFBYL
2 жыл бұрын
Have been struggling for 2 days until I see this video. Thank you!
@pauldncn1
3 жыл бұрын
Excellent Thank you Now I can get totals for expenditure types without moving columns 👍❤️
@andrewwest5344
2 жыл бұрын
Magic! just what I wanted to know and much simpler than I imagined!
@chh8860
3 жыл бұрын
I watched the video twice (because I had not finished my coffee and blueberry muffin). Candidly ... I don't use this function ... but I think it will be the 'next step' for me. A few ideas are simmering ... 🤔. Leila's instructional videos ... always a nice way to start the day ... thank you ... thank you ... thank you!
@LeilaGharani
3 жыл бұрын
Now I feel like having a blueberry muffin 😊
@Groovey0252
2 жыл бұрын
OMG...thank you so much. I've been stuck on this sumifs formula for 2 days. I didnt know how to add the second criteria. Thank you and you have alot of great videos!
@LeilaGharani
2 жыл бұрын
Happy to help!
@mamdouh733
3 жыл бұрын
This was totally awesome Leila!! I replaced this: =SUMIFS(total_gross,CASHIER_NO,Target!$A2,Segmentation,"HandSet")+SUMIFS(total_gross,CASHIER_NO,Target!$A2,Segmentation,"Home4G")+SUMIFS(total_gross,CASHIER_NO,Target!$A2,Segmentation,"Acc")+SUMIFS(total_gross,CASHIER_NO,Target!$A2,Segmentation,"Router") With This: =SUM(SUMIFS(total_gross,CASHIER_NO,Target!$A2,Segmentation,Logistics!I1:I4))
@LeilaGharani
3 жыл бұрын
That’s great! Thanks for sharing.
@mahidar100
3 жыл бұрын
I was thinking about this topic and here is Leila posting this video.. thanks for the lesson.. much needed
@LeilaGharani
3 жыл бұрын
You're welcome 😊
@nipunkavinda8254
3 жыл бұрын
It is endless journey to master excel. Thanks for this tip. Please do a "SUMPRODUCT" tutorial...
@sethforbes2739
2 жыл бұрын
I've spent hours upon hours watching different KZitem videos trying to find something that gets close to the problem I'm trying to solve, and your video is the closest I've found yet! Thank you so much, this was very helpful. :)
@shashank15jn
3 жыл бұрын
This was a life saver and the video was uploaded just in time when I was looking for it. Thanks much. Also, as others mentioned, is it possible in pivot table as well? That will be helpful as well.
@myameenk
6 ай бұрын
Hi Leila, Thanks for this video. Really appreciate.
@paulprobst7728
3 жыл бұрын
Such an elegant solution. Thank you, Leila!
@scottaroper
Жыл бұрын
Leila, you have saved me again! Thanks for the great content on your channel.
@LeilaGharani
Жыл бұрын
Glad you find the content useful!
@sharadpunita
2 жыл бұрын
Great video. I have been watching your videos for sometime now, and have subscribed after watching this video. Thanks
@joeyoukhanna6519
3 жыл бұрын
Leila, another great video, I always enjoy watching your videos, and every time I learn something new thank you. by the way, I love your coffee mug, good idea, where did you get it from? 🥰👍☕
@Hairletics
3 жыл бұрын
Thank you so much for this video! Spent half the day trying to figure out how to fix the spill issue.
@shreesparsha5824
Ай бұрын
Thanks for the video. I was wondering if there's a way to use the sumif to sum based on multiple criteria from the same column, provided the criteria is not listed separately as in this video. Taking this eg, Can the formula itself pick up each country and sum the values? I would appreciate your suggestions on this. Thank you Leila!
@khalilsial1
3 жыл бұрын
Good and efficient way to get values.
@chetanchavan8634
4 ай бұрын
Hi this is very usefully video. I have an query, if output required from multiple column values. What I should do?
@IAMATUNKU
Жыл бұрын
Hello Leila, thank you for such rich contents you put out on youtube... you have no idea how much you have help some of us build a career around Excel
@keishrich
2 жыл бұрын
I did not know my criteria could be a range so I would add multiple SUMIFS. Thank you Leila!
@mohamedkhattab3423
2 жыл бұрын
Very much useful after 1 full day trying to sumifs different criteria in the same column
@dex461
2 жыл бұрын
Thank you for the video! This just saved me a ton of time going forward updating a planning spreadsheet!
@LeilaGharani
2 жыл бұрын
Happy to help, Dexter!
@yoycab
3 жыл бұрын
always wondered how to shorten my sumifs formulas. finally saw the hack. many thanks for this tip!
@Ticky66MN
3 жыл бұрын
I love it! So simple and useful. Thank you.
@henrikmanukyan3152
Жыл бұрын
Hidden gem that would solves many of my problems
@Big_Ronnie_G
3 жыл бұрын
Learning something new with every video Leila
@AngelyPonts
2 жыл бұрын
Omg!!! Thank you so much! As always Leila saved the day. 🤗
@farzanmoha8935
3 жыл бұрын
Thank you Leila, I needed this 1 month ago and I searched and played with half day till I got it the same way you described here. It would have saved me half day if ...👍🏻
@veronicas6986
9 ай бұрын
Thank you very much for your input. You really help people in their work.
@LeilaGharani
8 ай бұрын
My pleasure!
@michaelpang4572
Жыл бұрын
Hi Leila, thank you for your tutorial. But I have one more question. If I want the result included " Utility & Game" "Asia & Europe" also, how to input the formula?
@nickleong5222
11 ай бұрын
I just have the same question as yours. Have you found the solution yet? I tried it in excel for long and can't get a solution
@Megaaslammji
Жыл бұрын
Hey Leila, this is awesome, thank you. Will this formula be working on data in Google sheet! seems like No. If anyone tried, please let me know here..
@utubeAgape
3 жыл бұрын
Love it - thanks for showing the different ways to do this common use scenario Leila!
@jonaslabitigan4070
3 жыл бұрын
I learn many things from you which is very helpful in my works, thanks
@lxz86
3 жыл бұрын
very clear, easy understand
@kartikanoerpratiwi2950
3 жыл бұрын
My favorite teacher ❤
@GiteshBajaj
3 жыл бұрын
Great video as always. Keep it up!
@agussuwito
3 жыл бұрын
Special give'solution Very great and complete Watching like
@kasondekasondel2885
3 жыл бұрын
Thank you Leila, from Zimbabwe
@derrektrykoski4750
2 жыл бұрын
Thank you so much. Game changer!
@JamesBond-qg5gx
6 ай бұрын
Thanks a lot for this very valuable info. I am facing problems as I have another multiple criteria from another column. The calculation is not accurate. (Two multiple criteria from 2 different columns in one sumifs) Kindly for your support.
@charbear252
Жыл бұрын
Great job again. I love your channel. I have a dilemma. My reports come into me in rows, but the weights that I need to add together are in column form, under each row. Each has a different amount of weights and each day they are different. Is there a way to automatically add the totals between these rows? There is no label for the weights, they are just entered under the shipping number, which is different for each row.
@engineervlogs913
8 ай бұрын
Wonderful I loved this ! Thanks for sharing
@LeilaGharani
8 ай бұрын
Our pleasure!
@legacygk2811
2 жыл бұрын
Just lovely! Thank so you much!!
@michaelvinueza4292
3 жыл бұрын
Great solution. Thank you.
@nickmouz7443
10 ай бұрын
Helpful as always! Thank you. :)
@G3nM
3 жыл бұрын
Every week I wait for Leila's video ❤️
@shailendranigam1386
3 жыл бұрын
Quick tip! loved it. Thanks, Leila, I wonder why it didn't click in my mind.
@anjinoureddine1513
3 жыл бұрын
Very very useful Thanks Leila.
@kishoredevrukhkar
2 жыл бұрын
Thanks for this formula. You are awesome. Can I sumifs by indirect formula which range is named? Please reply.
@asrajesh
3 жыл бұрын
Life saving tips
@Adam_K_W
2 жыл бұрын
I found this one while searching for a way to EXCLUDE Multiple Criteria, but sum the remaining Criteria. Despite trying several variants of the "" argument either referencing cells with the criteria I wanted to Exclude, or manually entering "01.107", etc. I couldn't get it to work. However, I nested the Unique Function into SUMIFS to ONLY sum up a set of unique values from a smaller range and that worked perfectly! Here's my example: =SUM(SUMIFS(N:N,A:A,UNIQUE(A15:A30))) where the criteria I wanted are in A15:A30 and the criteria I want to Exclude will always be found below Row 30...
@oliverscheurich9202
Жыл бұрын
Let's say your data is in range A1:B20 like this: invoice2 10 invoice7 20 invoice5 30 invoice2 40 invoice8 50 invoice7 60 invoice4 70 invoice2 80 invoice2 90 invoice1 100 invoice8 110 invoice2 120 invoice2 130 invoice8 140 invoice2 150 invoice7 160 invoice3 170 invoice1 180 invoice3 190 invoice2 200 You can then apply this formula to return the result of 980: =SUMIFS($B$1:$B$20,$A$1:$A$20,""&"invoice2",$A$1:$A$20,""&"invoice8") This would be more dynamic as you don't have to ensure that e.g. the exclude criteria always has to be entered below row 30.
@mategombas771
Ай бұрын
I knew i had to come here for the solution!
@chongyungkhong266
3 жыл бұрын
Hi Leila, how about if need to add one more criteria at "Division" (such as add "Game")? Because unable to obtain the right result after tried on the worksheet.
@Erethras
3 жыл бұрын
Brilliant, very useful! Thank you!
@sangramgandhi
3 жыл бұрын
Great solution. I was facing this issue, while preparing dashboard, will be able find workaround solution by using this formula. I am using SUMIFS and one of the criteria is less than cell reference (e.g. c$2). Its not working. what might be the solution.
@ExcelCurytec
3 жыл бұрын
Excellent, the functions in arrangements always simplify the work, greetings!
@douglasbrown5329
3 жыл бұрын
I can definitely use this in my Excel work. Thank you for providing another outstanding Excel video & formula tip!
@wayneedmondson1065
3 жыл бұрын
Hi Leila. Nice one! Thanks for sharing this solution :)) Thumbs up!!
@АдиКабиев
3 жыл бұрын
Thanks, Leila! Could you please explain how we can name Excel or other files properly.
@josealvesferreira1683
2 жыл бұрын
Congratulations, very good!
@Sir_Umar_Mughal
3 жыл бұрын
Best Teacher 🥰 Bestest Content 😇😇
@MrRichardlobo
3 жыл бұрын
Thank you Liela. This is going to make my work lot easier. One more question you Indian or Persian. ? ☺️
@WhosShamouz
3 жыл бұрын
Would you recommend doing it like that instead of using SUMPRODUCT directly? (As you showed in your video about SUMPRODUCT)
@naimurrahman5413
11 ай бұрын
thanks. works perfectly.
@muralithesupersaint5677
2 жыл бұрын
Thank U, it was very helpful... !!!
@samanthadaroga4811
Жыл бұрын
This a quite a helpful video. Thanks.
@bayarahmed2436
3 жыл бұрын
Useful as always !
@PramodKumar-fh6lm
Жыл бұрын
Thanks alot for this information 🙏
@chinthaka7245
Жыл бұрын
Thank you. very important....
@PracticalConstructions
3 жыл бұрын
Dear make basic video tutorials on PowerPoint . Please just like these . Love from Afghanistan ❤️
@abdallahdataguy
3 жыл бұрын
Assalaam alaikum. I am your brother from Tanzania, East Africa. How is the life there after Taliban takeover?
@PracticalConstructions
3 жыл бұрын
@@abdallahdataguy awesom❤️ , nothing irrigular . Same as before 2 years
@kamranmammadli5850
2 жыл бұрын
I am using TM1 and thank you for such a great content
@jamesliclican2374
3 жыл бұрын
Hello Miss, I've been enjoying all your Excel tutorials. If there's a chance can you also please make tutorials using alt shortcuts in mac. I recently switched from pc. I'm sure many mac user feel the same as I do. 🙏🙏🙏
@ihbachannel8219
2 жыл бұрын
Thanks for this wonderful video Leila! May I ask question if this formula can work also in Google Spreadsheet? If not, is there google spreadsheet formula that gives the same result for this video? Thank you for the answers!
@LeilaGharani
2 жыл бұрын
Yes, absolutely - formula works in Sheets too.
@jpgmedia8215
2 жыл бұрын
what if the region (g3:i3) is not entered, I have tried the result is 0. what is the additional formula for this case
@MisterBobi
2 жыл бұрын
Thank you so much Leila, this video helped me a lot!
@minabeshir2018
3 жыл бұрын
Awesome , Thank you Leila
@vishwa1767
3 жыл бұрын
Awesome. Please teach us how to create and edit videos like yours with a walkthrough tutorial.
Пікірлер: 328