Calculate totals for matching rows

[CaptainGravyBum]

Hello,
I'm in the need of a formula that is eluding me at the moment. From the sheet, I need column D to show the count of column C when column A & B data matches.
The match could be anywhere in the sheet - currently it is in order.
You can see that rows 3&4, 9>11, 14&15 and 23&24 are matched, so I only need the total on one of the rows when this happens - as illustrated.
Thanks in advance

Example.xlsx
	A	B	C	D
2	Article number	Order number	Count	Total
3	PBB12(MKM1)	204021	250
4	PBB12(MKM1)	204021	250	500
5	PFCF11E	204012	2	2
6	PFCF11E	204045	6	6
7	PFCF11E	203980	60	60
8	PFCF11E	204085	10	10
9	PBTF12	204125	10
10	PBTF12	204125	20
11	PBTF12	204125	50
12	PBTF12	204125	20	100
13	PBTF12	204127	10	10
14	PFCF11E	203134	45
15	PFCF11E	203134	15	60
16	PBB12(JE1)	204136	500	500
17	PBTF12	204136	10	10
18	PBB12(JE1)	204225	500	500
19	PBB12(JE1)	204229	500	500
20	PFCF11E	204284	10	10
21	PBTF12	204278	52	52
22	TGB	204278	7	7
23	PBB12(MKM1)	204402	30
24	PBB12(MKM1)	204402	300	330
25	PFCF11E	204450	2	2
Sheet1

 

[awoohaw]

try

Book1
	A	B	C	D	E
1
2	Article number	Order number	Count	Total
3	PBB12(MKM1)	204021	250
4	PBB12(MKM1)	204021	250	500	500
5	PFCF11E	204012	2	2	2
6	PFCF11E	204045	6	6	6
7	PFCF11E	203980	60	60	60
8	PFCF11E	204085	10	10	10
9	PBTF12	204125	10
10	PBTF12	204125	20
11	PBTF12	204125	50
12	PBTF12	204125	20	100	100
13	PBTF12	204127	10	10	10
14	PFCF11E	203134	45
15	PFCF11E	203134	15	60	60
16	PBB12(JE1)	204136	500	500	500
17	PBTF12	204136	10	10	10
18	PBB12(JE1)	204225	500	500	500
19	PBB12(JE1)	204229	500	500	500
20	PFCF11E	204284	10	10	10
21	PBTF12	204278	52	52	52
22	TGB	204278	7	7	7
23	PBB12(MKM1)	204402	30
24	PBB12(MKM1)	204402	300	330	330
25	PFCF11E	204450	2	2	2
Sheet5

Cell Formulas
Range	Formula
E3:E25	E3	=IF(COUNTIFS($A$3:$A$25,A3,$B$3:$B$25,B3)=COUNTIFS($A$3:$A3,A3,$B$3:$B3,B3), SUMPRODUCT(($A$3:$A$25=$A3)*($B$3:$B$25=$B3)*($C$3:$C$25)),"")

 

[CaptainGravyBum]

Hi @awoohaw
Spot on once again, thanks for the fast response.

 

[awoohaw]

Hi @awoohaw
Spot on once again, thanks for the fast response.

my pleasure, but please check again. I had missed one of your requirements and made a correction.

 

[CaptainGravyBum]

Hi @awoohaw
Spot on once again, thanks for the fast response.

try

Book1
	A	B	C	D	E
1
2	Article number	Order number	Count	Total
3	PBB12(MKM1)	204021	250
4	PBB12(MKM1)	204021	250	500	500
5	PFCF11E	204012	2	2	2
6	PFCF11E	204045	6	6	6
7	PFCF11E	203980	60	60	60
8	PFCF11E	204085	10	10	10
9	PBTF12	204125	10
10	PBTF12	204125	20
11	PBTF12	204125	50
12	PBTF12	204125	20	100	100
13	PBTF12	204127	10	10	10
14	PFCF11E	203134	45
15	PFCF11E	203134	15	60	60
16	PBB12(JE1)	204136	500	500	500
17	PBTF12	204136	10	10	10
18	PBB12(JE1)	204225	500	500	500
19	PBB12(JE1)	204229	500	500	500
20	PFCF11E	204284	10	10	10
21	PBTF12	204278	52	52	52
22	TGB	204278	7	7	7
23	PBB12(MKM1)	204402	30
24	PBB12(MKM1)	204402	300	330	330
25	PFCF11E	204450	2	2	2
Sheet5

Cell Formulas
Range	Formula
E3:E25	E3	=IF(COUNTIFS($A$3:$A$25,A3,$B$3:$B$25,B3)=COUNTIFS($A$3:$A3,A3,$B$3:$B3,B3), SUMPRODUCT(($A$3:$A$25=$A3)*($B$3:$B$25=$B3)*($C$3:$C$25)),"")

my pleasure, but please check again. I had missed one of your requirements and made a correction.

Is there a way to use this formula across rows without data in as well? I need to make sure the formula is there ready for the data to be imported because the data is dynamic.
I tried changing the row from 25 to 100 where relevant and all cells where there were values, now show as #value errors.

 

[awoohaw]

what is the formula that you put in cell E100?

if you didn't change the references inside the formula to expand the ranges from 25 to 100 the formula will fail.

If you are concerned about ever expanding rows, I suggest you put the data in a table. When you paste new data in a table the formulas automatically expand.

 

[CaptainGravyBum]

what is the formula that you put in cell E100?

if you didn't change the references inside the formula to expand the ranges from 25 to 100 the formula will fail.

If you are concerned about ever expanding rows, I suggest you put the data in a table. When you paste new data in a table the formulas automatically expand.

Only rows 3 to 25 have data in them currently, the rest are formulas which reference another sheet. So if there are more rows in the second sheet it will pull the data through.
I have tried changing the references in the formula, but it doesn't return any results at all.
I haven't posted the full workbook as it is quite extensive, i'll see what happens to the formulas the next time the data is imported.

 

[awoohaw]

Well, i'm not sure what all that means. But, I can say this. If you have different formulas in columns it is the start of a recipe for disaster.
Consistency in effective workbooks is critical. Report sheets should be separate from data sheets if at all possible. There is nothing wrong with formulas in data, as long as it is consistent. If you want to analyze something differently it should be on a new worksheet. (just my two cents, and I'm sure people here may disagree).