Hi to all
In range A4:A7 i have list of products
I have other table with names of factories where i type how many units of some product that factory made
Every factory make always the same product from the first list
Arghh its hard to explain
there are 30 factories..
number of factories are not always the same in same position
After i choose which product of 4 in list some factory made i type number of units done that day for each factory
what i need is count how many units of each is made that day
ex. apples, oranges, bananas and peach
some factory make something of those fruits and if factory1 made 10 apples, factory2 14 oranges, factory3 20 oranges, factory4 44 bananas and so on..
i need at the and this
apples: 100
oranges: 47
bananas: 200
peach: 32
what every factory make is in range B15:DN15 (every second column, and they are merged, so actually its every 4th)
in range B17:B118 is number of units made each day for selected factory
for second factory that list is in range F17:F118 and for next factory is 4 column ahead and so on..
I don't know how to describe it better and i hope u experts understand what i looking for
and i also hope ill get answer which will solve mine problem
In range A4:A7 i have list of products
I have other table with names of factories where i type how many units of some product that factory made
Every factory make always the same product from the first list
Arghh its hard to explain
there are 30 factories..
number of factories are not always the same in same position
After i choose which product of 4 in list some factory made i type number of units done that day for each factory
what i need is count how many units of each is made that day
ex. apples, oranges, bananas and peach
some factory make something of those fruits and if factory1 made 10 apples, factory2 14 oranges, factory3 20 oranges, factory4 44 bananas and so on..
i need at the and this
apples: 100
oranges: 47
bananas: 200
peach: 32
what every factory make is in range B15:DN15 (every second column, and they are merged, so actually its every 4th)
in range B17:B118 is number of units made each day for selected factory
for second factory that list is in range F17:F118 and for next factory is 4 column ahead and so on..
I don't know how to describe it better and i hope u experts understand what i looking for
and i also hope ill get answer which will solve mine problem