Find duplicate text and sum values in different columns

[CypherBit]

I have a table that has three columns.
A column contains values, B column contains part numbers and C column which also contains values. The sum total of values in column A and Column C should be the same for each part number. The same part number in column B can exist in the table just once or 20+ times.

I'd like to somehow find all duplicated part number that exist in column B and based on that sum up column A and column C so I'd see where the differences are. The table has about 2.000 rows so I can't do that manually.

Count 1	Part	Count 2
0​	10446005​	1​
0​	10446005​	1​
2​	10446005​
1​	10446005​	1​
0​	10446005​	1​
0​	10446005​	2​
0​	10446005​	1​
0​	10446005​	2​
6​	10446005​
0​	10446005​	3​
0​	10446005​	3​
0​	10446005​	3​
0​	10446005​	2​
0​	10446005​	1​
8​	10446005​
2​	10446005​	2​

This example is just for one part number. SUM in column A is 19, in column C 23.

Ideally I'd end up with:

Count 1	Part	Count 2
19​	10446005​	23​

I'm using Excel 2019, would prefer to do it formulas only if at all possible.

Any assistance is more than welcome.

 

[Fluff]

I'm using Excel 2019

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1	Count 1	Part	Count 2			Part
2	0	10446005	1			10446005	9	20
3	0	10446005	1			10446010	10	3
4	2	10446005
5	1	10446005	1
6	0	10446005	1
7	0	10446005	2
8	0	10446005	1
9	0	10446005	2
10	6	10446005
11	0	10446005	3
12	0	10446005	3
13	0	10446005	3
14	0	10446005	2
15	0	10446010	1
16	8	10446010
17	2	10446010	2
18
19
Main

Cell Formulas
Range	Formula
G2:G3	G2	=SUMIFS(A:A,B:B,F2)
H2:H3	H2	=SUMIFS(C:C,B:B,F2)
F2:F6	F2	=IFERROR(INDEX($B$2:$B$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/($B$2:$B$100<>"")/(ISNA(MATCH($B$2:$B$100,F$1:F1,0))),1)),"")

 

[CypherBit]

Thank you for the extremely quick reply.

I updated my account details, but I'm having trouble with the formulas, this is what I'm getting:

 

[Fluff]

In F2 the formula should be F$1:F1, not F$2:F2

 

[CypherBit]

In F2 the formula should be F$1:F1, not F$2:F2

Of course, thank you very, very much seems to work exactly as I hoped. You saved the day!

 

[Fluff]

Glad to help & thanks for the feedback.