trying to sum unique values based off of another column.

[johnsonmitch]

Column1 Column3
0011-1-1 50
0011-1-1 50
0011-1-1 50
0022-2-2 100
0022-2-2 100
0033-3-3 1000

Here is a simple form of my issue... I have multiple jobs in column 1 (3 different jobs). Some jobs are duplicated. Column 3 has the total parts produced. I would like a formula to run through my table and ignore all additional duplicated jobs....So, my answer would add 50+100+1000= 1,150. simple example.xlsx

[oeldere]

d3=countif($A$3:$A3,$A3)

After that a pivot table.

See the attached file.

[AlKey]

Or use formula

=SUMPRODUCT((A3:A8<>"")*(C3:C8)/COUNTIF(A3:A8,A3:A8))

Row\Col	A	B	C
2	Column1	Column12	Column2
3	0011-1-1		50
4	0011-1-1		50
5	0011-1-1		50
6	0022-2-2		100
7	0022-2-2		100
8	0033-3-3		1000
9
10			1150

[johnsonmitch]

Thank you so much for the help! Both methods worked! For me, I am going to use the formula, so the users don't have to take the data that gets output and then put it in a pivot table every time. The formula I can just enter on the template, and will autocalculate for me! Thanks again!!

[AlKey]

You're welcome and thank you for the feedback!