Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header
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:
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.