I asked this question the other day in a thread titled "This Has to be So Easy!" and got two great answers, but (my fault) I didn't describe the problem correctly. I finally figured out how to post tables so maybe this will help.
I have a widget factory. Each day there is a target for how many widgets are produced. There is an overall target of 650 produced by March 31, 2017. I'm interested in how far ahead or behind we are to targeted production at the end of each day (I'm open to ideas for just working with the 650 target, but I think that would require LOOKUP or COUNT functions that I don't know how to use). For instance, it does me little good to know we are -3 widgets behind 570 with a remaining 100 days to go. That's too wide of a picture and I want to keep it on a daily level.
<tbody>
</tbody>
I could probably figure this out using a bunch of extra columns, but I want to keep it as clean as possible with the fewest number of columns. Assume "Day" is in cell A1. Also notice that the factory was shut down on Wednesday.
The formula for E3 can't simply be =D3+C3 or D3-C3 for obvious reasons. The +/- will depend on whether there is an overage for that day (as there was on Thu) or we under produced (as we did on Mon). So I'm not sure how to rectify this without creating other columns that total results. Also, the shut down day is confusing me.
So the simplest way I can think of to explain it is that I need to produce 650 widgets by April. And I'd like to keep a running total of how far ahead/behind we are each day.
And maybe this should be another thread, but I'm also going to want to something very similar only with sales, with the total sales figure by end of March being $16,000 and I'm going to want to track each day's sales and the running difference of that too. I know it might seem silly as to why anyone would want to do this, but it's important to me.
I have a widget factory. Each day there is a target for how many widgets are produced. There is an overall target of 650 produced by March 31, 2017. I'm interested in how far ahead or behind we are to targeted production at the end of each day (I'm open to ideas for just working with the 650 target, but I think that would require LOOKUP or COUNT functions that I don't know how to use). For instance, it does me little good to know we are -3 widgets behind 570 with a remaining 100 days to go. That's too wide of a picture and I want to keep it on a daily level.
| Day | Target | Running | Actual | Running +/- |
| Target Total | Produced | Total | ||
| Mon | 10 | 10 | 7 | -3 |
| Tue | 5 | 15 | 7 | -1 |
| Wed | 0 | 15 | 0 | -1 |
| Thu | 10 | 25 | 15 | 4 |
<tbody>
</tbody>
I could probably figure this out using a bunch of extra columns, but I want to keep it as clean as possible with the fewest number of columns. Assume "Day" is in cell A1. Also notice that the factory was shut down on Wednesday.
The formula for E3 can't simply be =D3+C3 or D3-C3 for obvious reasons. The +/- will depend on whether there is an overage for that day (as there was on Thu) or we under produced (as we did on Mon). So I'm not sure how to rectify this without creating other columns that total results. Also, the shut down day is confusing me.
So the simplest way I can think of to explain it is that I need to produce 650 widgets by April. And I'd like to keep a running total of how far ahead/behind we are each day.
And maybe this should be another thread, but I'm also going to want to something very similar only with sales, with the total sales figure by end of March being $16,000 and I'm going to want to track each day's sales and the running difference of that too. I know it might seem silly as to why anyone would want to do this, but it's important to me.
