Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

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: https://pages.xelplus.com/sumifs-multiple-criteria

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 ► https://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: https://youtu.be/AZuBNWMh7VM

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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