+ Reply to Thread
Results 1 to 2 of 2

Multiple Criteria SUMIF Using Column as Negative Criteria

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Multiple Criteria SUMIF Using Column as Negative Criteria

    Hello Everyone,

    I've attached a sample workbook to show what I am trying to do. I would like the formula to say "if Sheet2!A:A is "MON" and if Sheet2!R:R matches Sheet3!A:A, and if Sheet2!I:I doesn't match any of the values from Sheet1L:L, then I'd like the sum of Sheet2!F:F. It seems pretty simple but I've tried a million different variations of SUMIFS, SUMIF, IF, AND, etc. and I can't figure it out.

    If someone could help, that'd be great! Thanks in advance!

    TestBook4.xlsx

  2. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: Multiple Criteria SUMIF Using Column as Negative Criteria

    Thanks all who took the time to check this out but I think I got it to work with a SUMPRODUCT formula.

    =SUMPRODUCT(--(Sheet2!A:A="MON"),--(Sheet2!R:R=A3),--(Sheet2!I:I<>Sheet1!O:O),Sheet2!F:F)

+ 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. SUMIF for multiple column/sheet criteria
    By preddy1110 in forum Excel General
    Replies: 1
    Last Post: 04-13-2012, 11:45 AM
  2. Replies: 2
    Last Post: 01-27-2012, 01:32 PM
  3. Multiple Sumif (Criteria within same column)
    By Thanksinadvance in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-20-2011, 09:35 AM
  4. SUMIF with multiple criteria, one criteria a specific string
    By Weasel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2008, 05:32 PM
  5. SumIF multiple column criteria
    By gd19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2008, 05:56 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