Sum all amounts of same criteria

[forginganewone]

I have a 25000 row sheet in which there are serial numbers in column A and amount is column B.
Lets suppose i take column A and paste it on another sheet and remove duplicates, now i have unique serials.
Now i want to Sum all the values (Column B) coming against these serials (Column A).

 

[Fluff]

How about, in C2 & copy down
=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$25000,A2,B$2:B$25000),"")

 

[forginganewone]

How about, in C2 & copy down
=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$25000,A2,B$2:B$25000),"")

Worked like a charm. Thank you so much for your time and help.

 

[Fluff]

Glad to help & thanks for the feedback

 

[Peter_SSs]

Note that Excel's built-in Pivot Table feature would also create that this of unique serial numbers and calculate the totals for you. It's on the Insert ribbon tab.

 

[forginganewone]

Thank you Peter for your valuable input. I wanted a formula particularly so that i can nest it with other criterieas later on. As i have to pick data from same source for different sheet with different requirements.