+ Reply to Thread
Results 1 to 4 of 4

Sumif fuctioin with mutliple criterias from a data list

  1. 02-28-2024, 06:51 PM #1
    JPRICH16
    JPRICH16 is offline
    Registered User
    Join Date
    02-11-2019
    Location
    toronto, canada
    MS-Off Ver
    2013
    Posts
    64

    Sumif fuctioin with mutliple criterias from a data list

    Hi Everyone,

    I need returns and orders from a specific customer.

    Orders is easy its: =SUMIFS(Data!$G:$G,Data!$D:$D,"Order",Data!$J:$J,Sheet2!$I$6,Data!$V:$V,">10/1/2023")

    So returns should be: =SUMIFS(Data!$G:$G,Data!$D:$D,"Return",Data!$J:$J,Sheet2!$I$6,Data!$V:$V,">10/1/2023")

    BUT

    A return can only be true IF the serial number being returned has been ORDERED AFTER the start date, in this case, 10/1/2023.

    Since the data can go back YEARS, i need to a formula search all return serial numbers that have an order date that is after the start date And had the same serial number.....or its overstated and wrong

    i cant figure it out!!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-29-2024, 03:25 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Sumif fuctioin with mutliple criterias from a data list

    Are you still using Excel 2013?

    The formulae don't match the data in the sample workbook. Please do the following:

    1. Adjust the formulae to match the sample data.
    2. Put the working formula in place (orders).
    3. For returns, give a manually calculated expected result.
    Last edited by AliGW; 02-29-2024 at 03:32 AM. Reason: Typo fixed.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 02-29-2024, 04:07 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sumif fuctioin with mutliple criterias from a data list

    As stated above, your words and your sample do not match. There is no ZR5F anywhere in the file.

    But, try this, copied across:

    =SUMIFS(Data!$G:$G,Data!$D:$D,D$5,Data!$V:$V,">="&$C6,Data!$J:$J,$A6)

    also note the change in the text in the blue cells. I did not check the results, as your sample far exceeded our guidelines (15,799 rows being somewhat in excess of 20 rows maximum).
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 02-29-2024, 05:46 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Sumif fuctioin with mutliple criterias from a data list 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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] Data validation list based on criterias
    By Imbizile in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2017, 04:56 AM
  2. Apply Filter Based on Mutliple Item Selection in Data Validation List
    By navs8603 in forum Excel General
    Replies: 1
    Last Post: 12-20-2011, 02:47 PM
  3. Sumif with about 1,000 criterias
    By FortuneSyn in forum Excel General
    Replies: 12
    Last Post: 03-17-2010, 03:05 PM
  4. Mutliple SUMIF's
    By robertguy in forum Excel General
    Replies: 4
    Last Post: 05-16-2008, 03:30 PM
  5. SUMIF with mutliple critera
    By bad in excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2006, 09:02 AM
  6. [SOLVED] Sumif with two criterias
    By gibz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-19-2006, 01:00 PM
  7. [SOLVED] SUMIF with 2 criterias
    By Laddy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-25-2005, 09:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1