Linking multiple cell data to a single cell

All,

Not sure how best to explain my problem, which may be why I'm not having any luck finding my answer through Google or the forum search. Can I have multiple cells be equally divided to total a static amount in another cell?

Example:

I have 4 cells with a value of 25 each that, when totalled, equal 100 (which is the value in another static cell). If I change the value in one of the cells to 10, I want the other 3 cells to automatically update to 30, 30 and 30.

Can this be done and how?

I appreciate any and all feedback on this. I'm stumped on this one.

Matt

Not sure of your exact circumstances, but assuming the input cell is A1, the cells to change are A2:A4, and the static total is in A5, you can use in cell A2:

=(A$5-A$1)/3

Then copy down to cells A3 and A4.

Not sure if this helps; let us know whether it does.

Jason

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.