coditional? If? diffrent
Posted by Squirrel on March 19, 2001 8:49 AM
Okay I have yet seen Dave and Mark stumped, and I have gained alot from reading your answers, and some I still do not understand but I am working on a tool to make my life simple at work. here goes:
(milk plant production)
12 Machines (worksheet for each machine)
Col G contains product no# ( 1-2002 unsorted)
Col I contains actual units run if any
3 products we will call "flush" Buttermilk=90 min. and choclate=30min and Juices run after dairy products=30 min.
What would I use to look at the acutal units after the "Flush and return the total min. on a page named EFF.
Keep in mind that if 1 or 5 products run after each of the 3 products I only need to count 1 flush time for each and "0" if no product is run after.
If you need an example tell me how to get it to you.
Thanks in Advance, Squirrel