Sumifs with a moving date range

nick6425

New member
Joined
Jun 16, 2014
Messages
1
Reaction score
0
Points
0
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
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,199
Reaction score
16
Points
38
Excel Version(s)
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.
 
Top