Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

Download the free workbook here: http://bit.ly/2osWAXD

Learn how to sum columns based on column header and on criteria in the rows. 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.

In the last video I showed you how to use the SUMIFS together with INDEX and MATCH sum based on header and criteria (https://youtu.be/2odvwY_mWN8).

In this video I show you how you can use SUMPRODUCT to get the same result. The formula uses SUMPRODUCT with criteria in the rows and in the columns.

Learn all about the SUMPRODUCT formula here: https://youtu.be/lzjc_eEISe8

VBA code from Excel MVP Charles Williams to time your formulas is included here: http://bit.ly/2q1fpSK

★ 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
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

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 SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria канала Leila Gharani