count how many of which

[dado6612]

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

 

[dado6612]

Oh i have new question
how to make this formula transpose?

data is same, cells are same, but table with sum now looks like this

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Choose factory
2	Fruit
3	Fruit	UpB
4	Apple	20
5	Orange	15
6	Bananas	40
7	Peach	15
8
9		Apple		Bananas		Peach		Apple		Apple	Orange	Bananas
10	1	25		32		25		23		0	0	0
11	2	73		46		23		26		0	0	0
12	3	27		68		121		71		0	0	0
...

I realized that this version is more efficient for me

ps: there is peach at the end of table, but jeanie's html maker don't allow me to use more than 12 columns

 

[Matty]

Where are your day numbers now situated?

Could you provide an example similar to what you provided in post #3?

Matty

 

[dado6612]

I can't edit previous post..

its same as #3

just, i moved table from range C3:E7 to J9:M

days are in column A, row 10 and downward
formula still must calculate how many apples are in day 1, oranges..and so for day 2..

count for apples in day 1 will be 55, orange 0, bananas 32 and so on..

its same principle as previous case, just now table is transposed, days are on the left and fruits are on the top

 

[Matty]

Even simpler with your new layout...

J10, copied down and across:

=SUMIF($B$9:$H$9,J$9,$B10:$H10)

Matty

 

[dado6612]

thanks again