Sum with change address

[sysuserwindows]

Hi,

I need a sum qty by column Code and Ref, the formula write in column E but is not correct

calculate sum.xlsx
	A	B	C	D	E
1	Code	product	qty	Ref
2	1000	Product A	5000	200201
3	1000	Product A	5100	200201
4	1000	Product A	5200	200201
5	1000	Product A	5300	200201
6	1000	Product A	5400	200201
7	1000	Product A	5500	200201	31500
8	2000	Product B	5600	200201
9	2000	Product B	5700	200201
10	2000	Product B	5800	200201
11	2000	Product B	5900	200201
12	2000	Product B	6000	200201	29000
13	3000	Product C	6100	200201
14	3000	Product C	6200	200201
15	3000	Product C	6300	200201
16	3000	Product C	6400	200201	25000
17	1000	Product A	6500	200202
18	1000	Product A	6600	200202
19	1000	Product A	6700	200202
20	1000	Product A	6800	200202
21	1000	Product A	6900	200202
22	1000	Product A	7000	200202	72000
23	2000	Product B	7100	200202
24	2000	Product B	7200	200202
25	2000	Product B	7300	200202
26	2000	Product B	7400	200202
27	2000	Product B	7500	200202	65500
28	3000	Product C	7600	200202
29	3000	Product C	7700	200202
30	3000	Product C	7800	200202
31	3000	Product C	7900	200202	56000
32	1000	Product A	8000	200203
33	1000	Product A	8100	200203
34	1000	Product A	8200	200203
35	1000	Product A	8300	200203
36	1000	Product A	8400	200203
37	1000	Product A	8500	200203	121500
38	2000	Product B	8600	200203
39	2000	Product B	8700	200203
40	2000	Product B	8800	200203
41	2000	Product B	8900	200203
42	2000	Product B	9000	200203	109500
43	3000	Product C	9100	200203
44	3000	Product C	9200	200203
45	3000	Product C	9300	200203
46	3000	Product C	9400	200203	93000
Sheet1

Cell Formulas
Range	Formula
E2:E46	E2	=IF(A2=A3,"",SUMIF($A$2:$A2,A2,$C$2:$C2))

 

[Oaktree]

Try E2=IF(AND(A2=A3,D2=D3),"",SUMIFS($C:$C,$A:$A,A2,$D:$D,D2)) copied down.