Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
Learn how to sum columns based on column header and on criteria.
Download the workbook here: http://bit.ly/2osWAXD
To solve this with SUMPRODUCT: https://youtu.be/9ICMErVqsJs
This example shows you a set of HR data. The aim is to create a report where the user inputs the cost center and selects which information they want to see for the cost center - for example the total salary, benefits or bonus information. The challenge is to SUM based on criteria (cost center) AND based on column header selection.
The solution shown in the video uses SUMIFS together with INDEX MATCH to provide a moving sum. The 2nd argument of the INDEX function using area numbers is also used to show an alternate solution.
To learn more about the SUMIFS function, check out this video:
https://youtu.be/AZuBNWMh7VM
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/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
Видео Excel SUMIFS: Sum Alternate Columns based on Criteria and Header канала Leila Gharani
Download the workbook here: http://bit.ly/2osWAXD
To solve this with SUMPRODUCT: https://youtu.be/9ICMErVqsJs
This example shows you a set of HR data. The aim is to create a report where the user inputs the cost center and selects which information they want to see for the cost center - for example the total salary, benefits or bonus information. The challenge is to SUM based on criteria (cost center) AND based on column header selection.
The solution shown in the video uses SUMIFS together with INDEX MATCH to provide a moving sum. The 2nd argument of the INDEX function using area numbers is also used to show an alternate solution.
To learn more about the SUMIFS function, check out this video:
https://youtu.be/AZuBNWMh7VM
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/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
Видео Excel SUMIFS: Sum Alternate Columns based on Criteria and Header канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCTExcel shortcut keys you SHOULD know!Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)Excel Sum(ifs) between dates, sum month & sum with multiple criteria4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table RangeLOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook IncludedExcel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and CriteriaHow to use Excel Index Match (the right way)Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functionsExcel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUMSearchable Drop Down List in Excel (Very Easy with FILTER Function)☑️ Top 30 Advanced Excel Tips and TricksCreate SMART Drop Down Lists in Excel (with Data Validation)How to Sum for a Specific Date Range in ExcelLookup values across multiple worksheets: VLOOKUP / INDEX MATCH in ExcelTutorial on SUMIF & SUMIFS Function in Excel with example (PRACTICE File included)