Where to begin???
On Jan 2, 9:44*am, PointerMan
wrote:
Part * * Jobs * * * * * * * * * * * * * * * * * * * * * * * Total *
A * * * * 10 * *5 * * 25 * *5 * * *220 * *999 * * * * * * ? *
B * * * * 10 * *5 * *70 * * 5 * * *999 * * * * * * * * * * *?
C * * * * 10 * *5 * *60 * *220 * *999 * * * * * * * * * * *?
D * * * * 4 * * 10 * *35 * *5 * * *220 * *999 * * * * * * ?
E * * * * 5 * * 70 * *100 * 20 * *5 * * * 220 * * * * * * ?
...
6700 rows deep x 50 columns wide
If Job 5 takes 1 day, Job 10 takes 1 day, Job 25 takes 3 days, etc what's
the easiest way to sum the total number of days for each part? *I could do it
manually, but I don't want 50 sub-calculations in my formula.
How do you know how many days per job? And what are all those numbers/
columns you posted?
|