Excel Sumifs - SUM different columns based on selectionHow 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:

Free download SUMIFS, SUMPRODUCT workbook example

Excel Dashboards that Inform & Impress

Use these techniques in your own reports

Unbeatable value!