+ Reply to Thread
Results 1 to 6 of 6

Combining SUMIF Statements

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Jacksonville, FL, USA
    MS-Off Ver
    Excel 2010
    Posts
    61

    Combining SUMIF Statements

    Is there a way to simplify this formula: =SUMIF(C4:C9,"<0")+SUMIF(G3:G9,"<0") ?

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

    Re: Combining SUMIF Statements

    That formula, probably not.
    It's about as simple as it's going to get.

    But is that a realistic example of what you want, or a shortened/simplified version?
    Are you really wanting to do several columns, like C G K O etc.. ?
    Is the pattern consistent (every 4 columns) ?

    With the 2 ranges being of different sizes (one is row 4 to 9, the other is 3 to 9),
    If that is really true, then there probably won't be a simple solution.
    But if that was just a typo, and the ranges actually are all the same size, then something can probably be worked out.

    But we need the specific details.

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Jacksonville, FL, USA
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Combining SUMIF Statements

    I set this up as an example - the two ranges are indeed dissimilar. Adding the two SUMIFs was all I could think of and wondered if there might be a more elegant way. Thanks for your time answering.

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

    Re: Combining SUMIF Statements

    What is in the cells 'between' the two ranges (D3:F9 and C3) ?
    If those cells are NOT numeric, then you can just do

    =SUMIF(C3:G9,"<0")

    It will just ignore any non numeric values.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Combining SUMIF Statements

    Another way to achieve this by using this array formula and need to confirm with Ctrl+Shift+Enter

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  6. #6
    Registered User
    Join Date
    08-21-2013
    Location
    Jacksonville, FL, USA
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Combining SUMIF Statements

    In the actual model, there are other data columns between the formula columns.
    Last edited by Phil Hageman; 12-19-2013 at 10:31 AM. Reason: spelling

+ 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. Combining if statements
    By SANJ in forum Excel General
    Replies: 3
    Last Post: 03-04-2010, 09:31 PM
  2. Help combining IF statements
    By Excel-erate2004 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2007, 11:32 AM
  3. Combining IF statements
    By Macmo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2006, 12:20 AM
  4. [SOLVED] Combining IF and multiple SUMIF statements, if A>0 & B is between
    By Lee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2005, 03:06 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