How to SUMIFS With Multiple Criteria In the SAME Column in Excel

Рет қаралды 336,736

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Want to sum values in Excel based on multiple criteria from the same column? This video is a must-see, ideal for Excel users looking to master advanced summing techniques.
⬇️ Download the file: pages.xelplus.com/sumifs-mult...
✨ Key Highlights:
▪️ SUMIFS with Multiple Criteria: Learn how to use SUMIFS for summing values like profit, filtering by criteria like region, even when they're in the same column.
▪️ Handling Multiple Conditions: Discover techniques to sum values for multiple regions (like Asia and Europe) within one column.
▪️ Dynamic Range Expansion: See how to easily expand your criteria range to include more conditions (e.g., adding Australia along with Asia and Europe).
▪️ Legacy Excel and Office 365 Compatibility: Understand how to make your SUMIFS function work in both Legacy Excel and Office 365 using SUMPRODUCT or array formulas.
▪️ Combining Multiple Column Criteria: Learn to combine criteria from different columns for more complex data analysis.
In this Excel formulas an function tutorial, you'll learn how to sum values based on MULTIPLE criteria that are in the SAME column. We generally use SUMIFS to sum values based on different criteria. However each criteria is in its own separate column. How can we sum values that are in the same column? In other words have an OR condition in SUMIFS?
That' what you'll find out in this video. I'll show you a solution for SUMIFS with OR criteria for both Office 365 and also for older Excel versions like Excel 2019, Excel 2016, 2013 and Excel 2010.
★★★ My Online Excel Courses ► www.xelplus.com/courses/
00:00 How to Use SUMIFS with Multiple Criteria in Same Column
00:27 SUMIFS with Multiple conditions in Multiple columns
02:04 SUMIFS with Multiple conditions in ONE column
03:55 Wrap Up
LINKS to related videos:
► Introduction to SUMIFS/COUNTIFS: • How to Use SUMIFS, COU...
➡️ 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

Пікірлер: 319

@LeilaGharani 6 ай бұрын

Grab the file I used in the video from here 👉 pages.xelplus.com/sumifs-multiple-criteria

@kvanniekerk3792 2 жыл бұрын

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.

@JoshColletta 2 жыл бұрын

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!

@sethforbes2739 2 жыл бұрын

I've spent hours upon hours watching different KZfaq 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. :)

@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

@utubeAgape 2 жыл бұрын

Love it - thanks for showing the different ways to do this common use scenario Leila!

@douglasbrown5329 2 жыл бұрын

I can definitely use this in my Excel work. Thank you for providing another outstanding Excel video & formula tip!

@paulprobst7728 2 жыл бұрын

Such an elegant solution. Thank you, Leila!

@ksdinkins 4 ай бұрын

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

@chrism9037 2 жыл бұрын

This was totally awesome Leila!!

@Ticky66MN 2 жыл бұрын

I love it! So simple and useful. Thank you.

@dimzer5594 2 жыл бұрын

The best Excel tutorials online!! Thank you and keep going!

@alexrosen8762 2 жыл бұрын

You saved my day today at work with your formula solution. Thanks Leila!

@farzanmoha8935 2 жыл бұрын

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

@ExcelCurytec 2 жыл бұрын

Excellent, the functions in arrangements always simplify the work, greetings!

@pauldncn1 2 жыл бұрын

Excellent Thank you Now I can get totals for expenditure types without moving columns 👍❤️

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

@bendreessen2809 5 ай бұрын

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 5 ай бұрын

Great to hear!

@myameenk 3 ай бұрын

Hi Leila, Thanks for this video. Really appreciate.

@markpodesta4605 2 жыл бұрын

Thank you Leila. You know your Excel stuff.

@andrewwest5344 2 жыл бұрын

Magic! just what I wanted to know and much simpler than I imagined!

@paulradon 2 жыл бұрын

You made my life easier. Thank you!!!

@vivekphadke16 2 жыл бұрын

A very smart solution, I was doing it a hard way (now I can only laugh at myself) Thanks Leila.

@GiteshBajaj 2 жыл бұрын

Great video as always. Keep it up!

@Erethras 2 жыл бұрын

Brilliant, very useful! Thank you!

@AngelyPonts 2 жыл бұрын

Omg!!! Thank you so much! As always Leila saved the day. 🤗

@anuvapriya3770 2 жыл бұрын

Wow amazing content and deep conceptual insight. Love it.

@wayneedmondson1065 2 жыл бұрын

Hi Leila. Nice one! Thanks for sharing this solution :)) Thumbs up!!

@IshaMalikOnGoogle 2 жыл бұрын

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

@nickmouz7443 7 ай бұрын

Helpful as always! Thank you. :)

@bayarahmed2436 2 жыл бұрын

Useful as always !

@shashank15jn 2 жыл бұрын

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.

@rafaeltalenjale2571 2 жыл бұрын

Thanks for this new learning. ❤️

@paolosoloperto4948 2 жыл бұрын

Great Leika....good job!

@jonaslabitigan4070 2 жыл бұрын

I learn many things from you which is very helpful in my works, thanks

@michaelvinueza4292 2 жыл бұрын

Great solution. Thank you.

@sharadpunita 2 жыл бұрын

Great video. I have been watching your videos for sometime now, and have subscribed after watching this video. Thanks

@legacygk2811 2 жыл бұрын

Just lovely! Thank so you much!!

@vijayarjunwadkar 2 жыл бұрын

Amazing idea! Liked it! 😊👍

@WYFBYL Жыл бұрын

Have been struggling for 2 days until I see this video. Thank you!

@VishwasKadrolli 2 жыл бұрын

Thank you so much! This helps a lot to me!

@keishrich 2 жыл бұрын

I did not know my criteria could be a range so I would add multiple SUMIFS. Thank you Leila!

@tintinlol7881 2 жыл бұрын

You are the best! Thank you.

@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!

@sirtajkhan3531 Жыл бұрын

Thank you so much, for this video it is a great help for me.

@e.a.dequilla1529 Жыл бұрын

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.

@anjinoureddine1513 2 жыл бұрын

Very very useful Thanks Leila.

@prof.code-dude2750 2 жыл бұрын

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 👍👍🙏🙏🔥🔥😀😀

@chh8860 2 жыл бұрын

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 2 жыл бұрын

Now I feel like having a blueberry muffin 😊

@SyedMuzammilMahasanShahi 2 жыл бұрын

Thanks for this wonderful share.

@yoycab 2 жыл бұрын

always wondered how to shorten my sumifs formulas. finally saw the hack. many thanks for this tip!

@minabeshir2018 2 жыл бұрын

Awesome , Thank you Leila

@shailendranigam1386 2 жыл бұрын

Quick tip! loved it. Thanks, Leila, I wonder why it didn't click in my mind.

@derrektrykoski4750 2 жыл бұрын

Thank you so much. Game changer!

@engineervlogs913 6 ай бұрын

Wonderful I loved this ! Thanks for sharing

@LeilaGharani 5 ай бұрын

Our pleasure!

@scottaroper Жыл бұрын

Leila, you have saved me again! Thanks for the great content on your channel.

@LeilaGharani Жыл бұрын

Glad you find the content useful!

@mahidar100 2 жыл бұрын

I was thinking about this topic and here is Leila posting this video.. thanks for the lesson.. much needed

@LeilaGharani 2 жыл бұрын

You're welcome 😊

@khaledsolieman1704 2 жыл бұрын

Amazing as usual

@MisterBobi 2 жыл бұрын

Thank you so much Leila, this video helped me a lot!

@muralithesupersaint5677 Жыл бұрын

Thank U, it was very helpful... !!!

@lxz86 2 жыл бұрын

very clear， easy understand

@martyc5674 2 жыл бұрын

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 2 жыл бұрын

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!

@masternecrushne 2 жыл бұрын

wow, it is really nice! thanks!

@samanthadaroga4811 Жыл бұрын

This a quite a helpful video. Thanks.

@kasondekasondel2885 2 жыл бұрын

Thank you Leila, from Zimbabwe

@Hairletics 2 жыл бұрын

Thank you so much for this video! Spent half the day trying to figure out how to fix the spill issue.

@kartikanoerpratiwi2950 2 жыл бұрын

My favorite teacher ❤

@dreamsunlimited0783 2 жыл бұрын

Useful information Thankyou

@MohammadAshooryan 2 жыл бұрын

It is very useful 👍 thank you for sharing 😊

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

@Big_Ronnie_G 2 жыл бұрын

Learning something new with every video Leila

@chinthaka7245 Жыл бұрын

Thank you. very important....

@naimurrahman5413 8 ай бұрын

thanks. works perfectly.

@PramodKumar-fh6lm Жыл бұрын

Thanks alot for this information 🙏

@pranitkhot6155 2 жыл бұрын

Thanks a lot for this video

@dex461 Жыл бұрын

Thank you for the video! This just saved me a ton of time going forward updating a planning spreadsheet!

@LeilaGharani Жыл бұрын

Happy to help, Dexter!

@adjalmohamed7810 2 жыл бұрын

thank you so much for this video

@veronicas6986 6 ай бұрын

Thank you very much for your input. You really help people in their work.

@LeilaGharani 5 ай бұрын

My pleasure!

@Mhziko 2 жыл бұрын

Every week I wait for Leila's video ❤️

@taizoondean689 2 жыл бұрын

Superb ma'am your techniques are really awesome 👍🥰

@josealvesferreira1683 2 жыл бұрын

Congratulations, very good!

@nipunkavinda8254 2 жыл бұрын

It is endless journey to master excel. Thanks for this tip. Please do a "SUMPRODUCT" tutorial...

@agussuwito 2 жыл бұрын

Special give'solution Very great and complete Watching like

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

@mohamedkhattab3423 2 жыл бұрын

Very much useful after 1 full day trying to sumifs different criteria in the same column

@Sir_Umar_Mughal 2 жыл бұрын

Best Teacher 🥰 Bestest Content 😇😇

@joeyoukhanna6519 2 жыл бұрын

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? 🥰👍☕