hi all , im having a little bother with a formula that counts my projected stock - it counts 3 days worth and I need it to count how much projected I have for each day going forward
in my tab "weekly optimisation report" column f g and h are what I project to make for the next 3 days when A matches T in flowrap generation
like so
=SUMIF('flowrap generation'!T:T,'weekly optimisation report '!A8,'flowrap generation'!V:V)
I need it to split the figure so it also matches the date in "weekly optimisation report " F7 , G7 and H7 when the same date appears in flowrap generation column B
I hope that all makes sense :-)
Bookmarks