+ Reply to Thread
Results 1 to 6 of 6

Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

  1. #1
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    Hello,

    I am hoping that someone can help me with the following issue. I need a formula that can sum up the total values in multiple columns based on the column headings plus criteria in other columns.

    I've shown an example of the issue below (workbook attached).

    Month Product Store A Store A Store B Store C
    April Couch 300 242 14 3
    May Sofa 131 413 131 3,242
    June Bed 1,413 1,413 2,422 242
    July Table 1,312 436 23,245 242

    For example, in this instance I want to summarize the total values in the columns Store A for the criteria Month = April and Product = Couch. The value would be 542 using this criteria.

    Does anyone know how this could be done?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    Solution deleted, does not work.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    Why do you have two columns for Store A?

  4. #4
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    It's a flaw right now in how the data is laid out. However, for right now I have to keep these columns separate.

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    Try this

    =SUMPRODUCT((A4:A7=A11)*(B4:B7=B11)*(C3:F3=C10)*(C4:F7))

  6. #6
    Registered User
    Join Date
    07-11-2011
    Location
    Gatineau, QC
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

    It works!!!! Thank you so much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Summing values based on criteria located in column and row headings
    By talbarnett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 02:18 AM
  2. [SOLVED] Sum columns based on column headings
    By Jario in forum Excel General
    Replies: 6
    Last Post: 06-29-2012, 10:37 AM
  3. Sum several columns based on column headings.
    By Jario in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 11:51 AM
  4. Transposing one column data to different columns based on their headings
    By bipindurgapal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2012, 06:35 AM
  5. Replies: 3
    Last Post: 09-27-2011, 01:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1