Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header

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

The new Excel Dashboards course is here!

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

Free Ebook


  1. Umer draz October 29, 2017 at 2:00 am - Reply

    Greate job Love you

    • Umer draz October 29, 2017 at 10:11 am - Reply


  2. subrata nandi March 22, 2018 at 4:25 am - Reply

    good very good video MAM

    • Leila Gharani March 22, 2018 at 8:38 pm - Reply

      Thank you! Glad you like it.

  3. JUN HUANG June 19, 2018 at 5:58 am - Reply

    You are the best!

Leave A Comment

Share This