Results 1 to 2 of 2

Thread: Sumifs with a moving date range

  1. #1

    Sumifs with a moving date range



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to identify the maximum demand for a given part within a specified lead time.

    =SUMIFS(G:G,F:F,"=I /*",K:K,"=<"&K2+($O$2/2),K:K,"=>"&K2-($O$2/2))


    Column G contains the number quantity supplied/demanded in a certain transaction, column F contains the identifier "I / O" to indicate that this is a demand transaction, column K contains the date of the transaction, and cell O2 contains the number of days of lead time.

    What I think my formula says (at least, what I want it to say) is: count all quantity for demand transactions occurring within plus or minus one-half of lead time.

    Best,
    Nick

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    365
    If you could share a sample sheet (with any sensitive data changed) it would answer a lot of queries and stop us guessing (wrongly) when trying to reproduce what you have.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •