How to SUM Different Columns based on Header?

Excel’s SUMIFS function makes it easy to sum columns based on different criteria. But how can you use the SUMIFS function to not just sum based on criteria, but also sum different columns based on the column header?

This video shows you how you can sum different columns based on user selection. This is great technique when you want to create dashboard / interactive type of reports.

Here is a version to SUM using the SUMPRODUCT FORMULA:

Download the Jumping Sum Workbook Here: