+ Reply to Thread
Results 1 to 2 of 2

Sumifs multiple criteria same range

  1. #1
    Registered User
    Join Date
    09-07-2021
    Location
    Michigan, US
    MS-Off Ver
    365
    Posts
    8

    Sumifs multiple criteria same range

    Hello,
    The attached is a pic from a pivot. Im trying to do a sumifs that has multiple criterias and ranges. However, some ranges have more than one criteria- ex: Highlighted in yellow is a range with multiple criteria- and when i try to enter two criteria using the same range, it gives me 0. Is there a way to add multiple criteria in the same range?

    Thank you kindly for your time!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Sumifs multiple criteria same range

    Can you be more specific about what you want to do? It would help if you showed what result you want from that data.

    When you say you want to use two criteria, what range do you want to apply those criteria two? By "multiple" do you mean sum all values that meet either criterion?

    There are no formulas in this file. What is the SUMIFS formula you are trying to use?

    SUMIFS by definition can specify multiple criteria but SUMIFS sums all values that meet all criteria. If you want values that meet any criterion, the simplest way to do it is to use multiple SUMIF or SUMIFS formulas. For example, if you have a list of numbers in A and you want to sum all the numbers with with Apple or Orange in column B, would do this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    if you do this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    the result will be 0 because no cell can be both Apple and Orange.

    Also it would be better to give the actual pivot table instead of a suggestion of what it looks like.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Sumifs with multiple criteria (where one is a range) ?
    By Jeferson11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2019, 12:10 PM
  2. Replies: 3
    Last Post: 02-02-2017, 04:32 AM
  3. [SOLVED] SUMIFS with multiple criteria WITH specified dynamic range criteria
    By dluhut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2017, 11:03 AM
  4. How to sum SUMIFS - multiple criteria for one criteria range???
    By trstew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2016, 02:37 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