Linking multiple cell data to a single cell

Hey guys,

Thanks for the quick response. Here's my specific situation.

I am trying to build an Excel sheet to track production of a piece of machinery at our plant. Current, we are budgeted in a 1-month time frame for that machine to produce 1,000 pieces.

During that month, the machine may be down 1, 2 or 3 days due to non-production days - could be any day in a given month. Also, the machine may be idle for 8-hours for maintenance on any given day.

So, for example... if the machine is scheduled to produce 1,000 pieces in that month and there are 28.667 production days (2 days no-production; 8 hours maintenance), I want each of the 28.667 days to evenly distribute the total number of pieces needed to be created each day to still achieve the budgeted total of 1,000 pieces for the month.

I would prefer to lay it out in a calendar-type of format, which complicates things because it will require each day to automatically update when another day changes.

I appreciate your help with this!

Quick update. I was able find a way to accomplish what I was trying to do. It's a little more combersome than I was hoping for but not too bad and is accomplishing exactly what I wanted it to do. Thanks, again, for the quick replies.