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

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

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.

⬇️ Download the free workbook here: https://pages.xelplus.com/sumproduct-...

In the last video I showed you how to use the SUMIFS together with INDEX and MATCH sum based on header and criteria (   • Excel SUMIFS: Sum Alternate Columns b...  ).

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:    • How to Use SUMPRODUCT in Excel  

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

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

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ 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:   / lgharani  
LinkedIn:   / 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