+ Reply to Thread
Results 1 to 4 of 4

sumifs include/ include criteria

  1. 04-14-2016, 07:21 AM #1
    Burt_100
    Burt_100 is offline
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Donemana, NI
    MS-Off Ver
    Excel 2007
    Posts
    386

    sumifs include/ include criteria

    I am trying to use the below sumifs formula to include the first 2 criteria and exclude the 2nd to but cannot seam to get it working?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-14-2016, 07:26 AM #2
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: sumifs include/ include criteria

    Good afternoon Burt_100

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

    Note B5000 in your formula should be B6000

    HTH

    DominicB
    Last edited by dominicb; 04-14-2016 at 07:29 AM.
    Reply With QuoteRegister To Reply
  3. 04-14-2016, 07:26 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: sumifs include/ include criteria

    All ranges have to be the same. Change the 5000 to 6000
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 04-14-2016, 07:34 AM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: sumifs include/ include criteria

    ..I'm assuming that all those criteria are all AND conditions. For the specific example you give there are no D0215 or N0300
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 where one criteria needs to be "does not include"
    By pshearer in forum Excel General
    Replies: 1
    Last Post: 11-08-2015, 01:25 PM
  2. [SOLVED] Using SUMIFS but criteria also include all
    By davidfromkent in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-22-2015, 07:42 AM
  3. Is it possible to include two sumifs statements into one function?
    By VBAhelp3456 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2015, 04:36 AM
  4. right formula to include it in conditional format when I need to include many criterias
    By MGadAllah in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-26-2014, 01:05 PM
  5. [SOLVED] Editing a Macro to include multiple rows and include text formatting for leading zeros
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2014, 09:50 AM
  6. To Include or Not Include Holidays When Forecasting
    By mycon73 in forum Excel General
    Replies: 7
    Last Post: 11-03-2013, 04:09 PM
  7. [SOLVED] Using SUMIFS, how to create criteria to include if cell doesn't match specific data
    By Dena in forum Excel General
    Replies: 4
    Last Post: 06-27-2012, 03:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1