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 Waterfall Charts course is here!

Now available on Udemy

Impressive Excel Waterfall Charts for your reports.
Redeem your coupon for 67% 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.

Leave A Comment

Share This