+ Reply to Thread
Results 1 to 9 of 9

Adding further criteria in SUMIFS formula (valid combination of two columns)

  1. #1
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    165

    Adding further criteria in SUMIFS formula (valid combination of two columns)

    Hi,

    I have this formula

    SUMIFS(X:X,U:U,A4,V:V,B4,W:W,">="&C4)

    Basically, this formula is saying sum all the values in column X for where:

    1). The values in column U = A4 AND
    2). The values in column V = B4 AND
    3). The values in column W greater than equal to C4.


    Capture.JPG


    The issue I have now is that I need to incorporate a further condition to this formula.
    The condition is only execute this formula if:

    Capture2.JPG


    Does that make sense or it is not clear?


    Thank You
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,774

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    It would help if you attached a sample Excel file, rather than a picture of one.

    See the yellow banner at the top of the screen for details of how to do this.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    165

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    Hi,

    I have attached sample file.
    Password is PRM.

    Please can you help?

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,436

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    That file is password protected. I cannot open it.

  5. #5
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,278

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    Jazzer, the OP posted the pwd in post #3
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  6. #6
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,278

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    Would that be =IF(and(B4="Sub",V4="Senior"),0,SUMIFS(X:X,U:U,A4,V:V,B4,W:W,">="&C4))

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,436

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    Quote Originally Posted by Pepe Le Mokko View Post
    Jazzer, the OP posted the pwd in post #3
    smack.gif Sorry, read too fast.

  8. #8
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    165

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    Thanks Pepe Le Mokko!!

  9. #9
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,278

    Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

    You're welcome

+ 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. Adding Dynamic Criteria to SUMIFS from Drop-Down Box
    By dimitrisnj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-03-2020, 08:18 AM
  2. Replies: 4
    Last Post: 06-14-2017, 01:51 AM
  3. Using Sumifs when the criteria is a function of two columns
    By hatzopoulos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2015, 09:00 PM
  4. [SOLVED] SUMIF or SUMIFS adding time where criteria is in multiple columns
    By 66ev in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2013, 02:21 PM
  5. which formula to use for adding two columns, according to specific criteria
    By benji8798 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2013, 06:12 AM
  6. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  7. SUMIFS and VLOOKUP combination across sheets; dragging formula
    By alillian in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-09-2012, 10:21 AM

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