+ Reply to Thread
Results 1 to 4 of 4

How to sum SUMIFS - multiple criteria for one criteria range???

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    How to sum SUMIFS - multiple criteria for one criteria range???

    I'm trying to find a better way to sum multiple criteria for the same criteria range instead of adding another SUMIFS for every criteria cell. Check out my formulas in Row 77 - Holy Cow! Yes, they work, but I know there's a way to use the entire range of criteria in Col. E (Table worksheet)...

    Can someone please point me in the right direction? I don't need explicit instructions, just need to spend time on something that I know can work...

    Thanks for any advice!
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to sum SUMIFS - multiple criteria for one criteria range???

    Try
    =SUMPRODUCT(SUMIFS(Table!$C$3:$C$66,B$3:B$66,Table!$E$17:$E$23))


    And FYI, this is just a little nitpicky I guess.
    But it's only 1 criteriarange, so you can use sumif instead of sumifS
    =SUMPRODUCT(SUMIF(B$3:B$66,Table!$E$17:$E$23,Table!$C$3:$C$66))

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: How to sum SUMIFS - multiple criteria for one criteria range???

    although I don't follow the results, I think it can easier be done with a pivot table.

    see the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: How to sum SUMIFS - multiple criteria for one criteria range???


+ 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. Replies: 3
    Last Post: 12-09-2015, 03:10 AM
  2. Sumifs criteria between multiple range in single cells
    By silambarasan.J in forum Excel General
    Replies: 3
    Last Post: 08-18-2015, 05:57 AM
  3. [SOLVED] SUMIFS Equivalent for Excel 2003 with multiple criteria and range arguments
    By DEER30 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2014, 01:19 AM
  4. SUMIFS with a criteria range ?
    By vemix in forum Excel General
    Replies: 6
    Last Post: 12-20-2012, 11:56 PM
  5. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  6. SUMIFS with multiple values for one criteria range
    By Harsha Haridas in forum Excel General
    Replies: 9
    Last Post: 01-27-2012, 06:08 AM
  7. Replies: 1
    Last Post: 05-16-2011, 05:00 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