I am trying to set up a workbook to help with scheduling on a production line. There are five stations that can run five different products, each product can have up to three different stages tied to one robot. I need a formula that will help with the tedious task of keeping track of quantities of various stages placed on the schedule. I am using 2010 at home and 2007 at work. For example:
Cell
A B C
QTy PRODUCT STAGES
1 1 12154 2
2 1 3005 1
3 1 3005 2
4 3 12154 6
5 2 3005 3
6 6 6220 5
7 6 6220 1
8 6 6220 2
9 10 12154 1
10 10 12154 2
How would a formula be written so that when a number is placed in column c the corresponding quantity from column is added and placed into the designated cell? For instance, if cell E6 is designated to receive the sum of all stage 2 quantities it would display 18 since there are four products requiring stage 2 ( 12154,3005,6220, and 12154 again) and the combined quantity is 18. Would this be a function of a formula or a macro or is it even possible?
Thanks in advance
Bookmarks