Summarising Values

[Steve 1962]

Hi

I would like to have formulas in columns K, L, M & N that summarise the various categories from the source data located in columns A to E and H.

There are two main headings in columns K to N (Black & Red) which both have two sub-categories (Kgs & Fee).

Each row in columns K to N are summarising by each day.

Thanks

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Month	Car	Goods	Kgs	Fee1	Fee2	Fee -Total		Summary	Black - Kgs	Black - Fee	Red - Kgs	Red - Fee
2	1/07/2019	1/07/2019	Black	Apples	0			0		1/07/2019	65	563	25	57
3	1/07/2019	1/07/2019	Black	Oranges	0			0		2/07/2019	220	53	129	168
4	1/07/2019	1/07/2019	Black	Bananas	50	23	14	37		3/07/2019	816	840	52	263
5	1/07/2019	1/07/2019	Black	Oranges	0			0		4/07/2019
6	1/07/2019	1/07/2019	Black	Grapes	5	11	65	76		5/07/2019
7	1/07/2019	1/07/2019	Red	Carrots	15	22	15	37		6/07/2019
8	1/07/2019	1/07/2019	Black	Mango	0			0		7/07/2019
9	1/07/2019	1/07/2019	Black	Nuts	10	150	300	450		8/07/2019
10	1/07/2019	1/07/2019	Black	Tomato	0			0		9/07/2019
11	1/07/2019	1/07/2019	Red	Onion	10	5	15	20		10/07/2019
12	2/07/2019	1/07/2019	Black	Apples	0			0		11/07/2019
13	2/07/2019	1/07/2019	Black	Oranges	0			0		12/07/2019
14	2/07/2019	1/07/2019	Black	Bananas	0			0		13/07/2019
15	2/07/2019	1/07/2019	Red	Oranges	26	55	41	96		14/07/2019
16	2/07/2019	1/07/2019	Red	Grapes	15	11	14	25		15/07/2019
17	2/07/2019	1/07/2019	Black	Carrots	220	35	18	53		16/07/2019
18	2/07/2019	1/07/2019	Black	Mango	0			0		17/07/2019
19	2/07/2019	1/07/2019	Black	Nuts	0			0		18/07/2019
20	2/07/2019	1/07/2019	Red	Tomato	62	15	14	29		19/07/2019
21	2/07/2019	1/07/2019	Red	Onion	26	13	5	18		20/07/2019
22	3/07/2019	1/07/2019	Red	Apples	15	24	14	38		21/07/2019
23	3/07/2019	1/07/2019	Red	Oranges	5	25	26	51		22/07/2019
24	3/07/2019	1/07/2019	Red	Bananas	6	1	58	59		23/07/2019
25	3/07/2019	1/07/2019	Black	Oranges	0			0		24/07/2019
26	3/07/2019	1/07/2019	Black	Grapes	816	225	615	840		25/07/2019
27	3/07/2019	1/07/2019	Red	Carrots	5	16	21	37		26/07/2019
28	3/07/2019	1/07/2019	Red	Mango	6	25	14	39		27/07/2019
29	3/07/2019	1/07/2019	Red	Nuts	15	24	15	39		28/07/2019
30	3/07/2019	1/07/2019	Black	Tomato	0			0		29/07/2019
31	3/07/2019	1/07/2019	Black	Onion	0			0		30/07/2019
Sheet2

Cell Formulas
Range	Formula
B2:B31	B2	=A2-DAY(A2)+1
D12:D31	D12	=D2
H2:H31	H2	=F2+G2

 

[Fluff]

How about, in K2 filled down
=SUMIFS(E:E,A:A,J2,C:C,"Black")

In L2
=SUMIFS(H:H,A:A,J2,C:C,"Black")

And the same for the other two columns, but change Black to Red

 

[Steve 1962]

Works fine. Great thank Fluff.

 

[Fluff]

You're welcome & thanks for the feedback