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

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.

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

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:

🚩Let’s connect on social:

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

[kvanniekerk]

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]

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

[martyc]

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.

[vivekphadke]

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

[bendreessen]

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

[narinderkumar]

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-dude]

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

[sethforbes]

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

[WYFBYL]

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

[pauldncn]

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

[markpodesta]

Thank you Leila. You know your Excel stuff.

[JoshColletta]

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!

[e.a.dequilla]

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.

[mategombas]

I knew i had to come here for the solution!

[andrewwest]

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

[alexrosen]

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

[NetDijk]

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.

[Groovey]

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!

[IshaMalikOnGoogle]

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

[chh]

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!