Sumif and Min?

[mrr2]

Hi all, i am tryign to put in a formula into row 7 (highlighted) that only sends out deliveries once a full truck load has been reached in production. Can someone help me?
Thank you

Deliveries help 7.12.13.xlsx

[cheal2]

Hi,

Cell I7 has the following equation which should work for all other cells to the right.

Please Login or Register  to view this content.

Hope this helps.

[mrr2]

Thanks Cheal2 - appreciated...

I also got it work doing this:

Please Login or Register  to view this content.

case closed thanks again Cheal2