+ Reply to Thread
Results 1 to 2 of 2

Sumif (or) where criteria = any value in a column

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    London
    MS-Off Ver
    Office 365 ProPlus 64 bit
    Posts
    35

    Sumif (or) where criteria = any value in a column

    Hiya!

    Was looking for some help with building a sumif formula with multiple or criteria, which uses cell references to define the or criteria.

    In Tab 2 column A, I have a formula creating a unique dynamic range (which has the possibility to list up to 100 values), so I obviously don't want to use sumif with 1 cell reference + sumif with 1 cell reference + etc etc.

    What would be ideal would basically be:

    SUMIF(CriteriaRange, Criteria, SumRange)

    SUMIF(Tab1B:B, Tab2A:A, Tab1I:I)

    But I'm aware the sumif can't handle multiple or criteria using cell references natively.


    I've seen some suggestions to use sumproduct as below;

    SUMPRODUCT(SUMIF(Tab1B:B, Tab2A:A ,Tab1I:I))

    But that is evaluating to 0, so assuming I'm not using it correctly or that's a dead-end?

    Many thanks for any advice.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,215

    Re: Sumif (or) where criteria = any value in a column

    Hi,
    can you please attach the file?

+ 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 with multiple criteria in one column
    By Workaccount1998 in forum Excel General
    Replies: 25
    Last Post: 03-13-2020, 12:44 PM
  2. Sumif Criteria from List in another column
    By Dormie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-17-2018, 11:10 AM
  3. [SOLVED] Multiple Criteria SUMIF Using Column as Negative Criteria
    By freybe06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 04:46 PM
  4. Sumif when sum range is in different row/column than criteria
    By inincubus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 02:00 PM
  5. Multiple Sumif (Criteria within same column)
    By Thanksinadvance in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-20-2011, 09:35 AM
  6. Sumif with criteria for Row and Column
    By gigiw1986 in forum Excel General
    Replies: 3
    Last Post: 02-20-2010, 05:16 AM
  7. SumIF multiple column criteria
    By gd19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2008, 05:56 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