How to SUMIFS With Multiple Criteria In the SAME Column in Excel
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
Download the file: https://www.xelplus.com/sumifs-multiple-criteria-in-a-single-column/
LINKS to related videos:
► Introduction to SUMIFS/COUNTIFS: https://youtu.be/AZuBNWMh7VM
★ 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/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel
Видео How to SUMIFS With Multiple Criteria In the SAME Column in Excel канала Leila Gharani
★★★ 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
Download the file: https://www.xelplus.com/sumifs-multiple-criteria-in-a-single-column/
LINKS to related videos:
► Introduction to SUMIFS/COUNTIFS: https://youtu.be/AZuBNWMh7VM
★ 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/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel
Видео How to SUMIFS With Multiple Criteria In the SAME Column in Excel канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)Answering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone)3 EASY Ways to Find and Remove Duplicates in Excel15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook IncludedExcel SUMIFS: Sum Alternate Columns based on Criteria and HeaderExcel shortcut keys you SHOULD know!Excel Sum(ifs) between dates, sum month & sum with multiple criteriaTOP 10 Outlook Tips EVERY Professional NEEDS To Know (in 2021)How to use the SUMIF and SUMIFS Functions in Microsoft Excel for BeginnersSURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)Consolidate & Clean Multiple Excel Sheets in One Pivot TableExcel for Accounting - 10 Excel Functions You NEED to KNOW!When Should you Use the Hash Sign (#) in Excel Formulas?Searchable Drop Down List in Excel (Very Easy with FILTER Function)SUMIFS Function in Excel - How to Use SUMIFS function with 5 ExamplesAdvanced Pivot Table Techniques (to achieve more in Excel)Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)Breaking News! We FINALLY get the Excel functions we've been Wanting!