sum corresponding number of duplicate ID

[alireza123456]

HI

my question:
if a1 and a2 are same in A then sum b1 and b2 in new work sheet and retain only one of a1 and a2.

thanks

[Glenn Kennedy]

To return the unique IDs

=IFERROR(INDEX($A$2:$A$15,MATCH(0,INDEX(COUNTIF($I$1:$I1,$A$2:$A$15),0),0)),"")

To return the totals:

=IF(I2="","",SUMIF(A:A,I2,B:B))

See sheet attached.

[Glenn Kennedy]

Incidentally, I put the 2 formulae in i2 and J2, respectively, so that I could see your expected answer.

[Olly]

Easiest way is to use a pivot table.

See attachment for an example (with pivot solution in columns K:L)

[alireza123456]

Thanks olly
Thanks Glenn