I am trying to track running averages from one process to another, daily and
weekly. The issue that I have is that we are running product in lots and not
all of the lots are completed in one day. So I might have started 10 lots and
only 8 are complete so currently the average is looking at the number of
completed lots and dividing by the number of started lots. Can someone tell
me how to set up the work sheet so that the average is just the completed
lots and as the others get completed the average is recalculated.

Thanks