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:

Excel Dashboards that Inform & Impress

Use these techniques in your own reports

Unbeatable value!

LEARN MORE

9 Comments

Umer draz October 29, 2017 at 2:00 am

Greate job Love you
- Umer draz October 29, 2017 at 10:11 am
  
  Awsome
subrata nandi March 22, 2018 at 4:25 am

good very good video MAM
- Leila Gharani March 22, 2018 at 8:38 pm
  
  Thank you! Glad you like it.
- Eduardo Gosling April 16, 2019 at 12:06 pm
  
  Hi. Congratulations for the excellent video. I would like to have a huge help on this one. I have a spreadsheet with 121 columns. 112 of them are values which can be summed (in my case, those columns are related to employees earnings and discounts). In order to make final user analysis more simple, user grouped some of earnings in categories. For example, a category EXTRA HOURS refers to a total of 4 different types of extra hours (i.e. 4 columns in the base spreadsheet). This means that I need to sum columns G, H, J and M to present extra hours total. However, I have 16 months in spreadsheets. Columns positions varies from month to month. In a certain month I need to sum G,H,J,M; in another month columns that I need to find based on headers name which are the items which belongs to a Category. I was able to address the right spreadsheet based on user selection. I have difficulties in to sum the columns which varies depending on the spreadsheet.
  - Bryon Smedley April 19, 2019 at 12:56 pm
    
    Thank you for your question. To aid in answering your question, the following link to the Microsoft Excel Tech Community would be the best place to pose your question. If you have a sample file to upload, this would greatly aid in developing a course of action.
    
    The Excel Tech Community has some of the finest minds in the industry. No matter your issue, I’m certain someone there can inform you of the best way to reach your solution.
    
    Microsoft Excel Tech Community
    
    With over 25K members and almost 30K posts, your solution is either ready and waiting or has the possibility of being answered more quickly than we may be able.
    
    Thank you for taking the time to write. I hope you find success with this fantastic group of Excel enthusiasts.
    
    The XelPlus Team
JUN HUANG June 19, 2018 at 5:58 am

You are the best!
Joe November 1, 2018 at 8:16 pm

Pretty okay vid.
Pradyumn Mishra November 20, 2019 at 6:01 am

Thanks very good Video Mam

Comments are closed.