Hello,
I need assistance with a formula to distribute data.
I need to distribute a production quantity evenly across month cells as whole numbers and including new quantity in following months, based on multiple reference numbers, start dates, end dates, and quantity to produce data.
Please reference the attachment.
IF any reference numbers in B9:B17 = B4 and the Start Date in C9:C17 is between 1 January 2021 - 31 January 2021, I want the quantity distributed evenly and in whole numbers from C4 through the End Date in D9:D17.
Additionally, I need the distributed quantity to add onto additional data inputs.
So if the requirement I mentioned about distributes the quantity in E9 though cells C4:CE4, I need the quantity in E10 distributed across D4:G4 and added to the quantity distributed from E9.
Thank you in advance for your help!
Hi David,
Welcome to our forum!
You can use the DATEDIF function to calculate the number of periods and then use SUMIFS to summarsie the data across the periods. See file attached.
Note: if you can't produce fractions of units you can round up the quantity per month value using the ROUNDUP function.
Mynda
