Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

 

 

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

Related topics:

• Excel: How to Best Import External Data into Excel and Import data from the Web to Excel
• Excel: Inspecting Excel Spreadsheets for hidden information 
• Excel Solver example and step-by-step explanation
• Excel Goal Seek Explained in Simple Steps