Okebiz Video Search



Title:Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
Duration:10:54
Viewed:233,655
Published:21-04-2017
Source:Youtube

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/1327...

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347...
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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria) Excel SUMIFS (better version of SUMIF), COUNTIF...
14:04 | 816,336
Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps Excel OFFSET Function for Dynamic Calculations ...
14:15 | 445,796
Excel Sum(ifs) between dates, sum month & sum with multiple criteria Excel Sum(ifs) between dates, sum month & sum w...
08:44 | 280,398
Excel 2016 Advanced Excel 2016 Advanced
38:45 | 446,540
Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria Excel SUMPRODUCT with Criteria: SUM Alternate C...
10:55 | 41,654
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row) Create Multiple Dependent Drop-Down Lists in Ex...
11:57 | 451,228
50 Ultimate Excel Tips and Tricks for 2020 50 Ultimate Excel Tips and Tricks for 2020
50:17 | 583,699
Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel Lookup values across multiple worksheets: VLOOK...
13:10 | 440,349


coinpayu