+ Reply to Thread
Results 1 to 5 of 5

Multiple Sumif Criteria formula not working

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Multiple Sumif Criteria formula not working

    In cell H15 & J15 I have a sumifs formula where I am trying to sum up the values for 2 separate fields using {}. I seem to have problems when I am using the {} in one sumifs formula for 2 separate criteria, but if I only use it once in a sumifs it works fine. For instance in the attachment cells D15 & F15 are giving me the correct values. In the attachment H15 should be 24,068 and J15 should be 642,724.71 and I have the data that supports this on the query tab. Obviously I have something wrong, but not sure what I need to do to correct it.

    Thanks,

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,120

    Re: Multiple Sumif Criteria formula not working

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,948

    Re: Multiple Sumif Criteria formula not working

    In the second array {} separate the values with a semi colon instead of a comma

  4. #4
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Re: Multiple Sumif Criteria formula not working

    Fluff13....that did it....thank you.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,948

    Re: Multiple Sumif Criteria formula not working

    You're welcome & thanks for the feedback

+ 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. [SOLVED] SUMIF Formula with Multiple Criteria
    By hammer2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-12-2018, 02:52 AM
  2. Formula to sumif with multiple criteria
    By hern in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-16-2017, 06:56 PM
  3. trying to use multiple list criteria in sumif with comma, not working?
    By Prodschdler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2014, 03:27 PM
  4. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  5. Sumif formula using multiple criteria
    By juksie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2012, 05:44 AM
  6. sumif formula multiple criteria
    By simpson in forum Excel General
    Replies: 13
    Last Post: 07-04-2011, 07:36 AM
  7. Multiple Criteria in a SUMIF formula
    By JCARROLL in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 05:05 PM

Tags for this Thread

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