Quote:
Originally Posted by Shorabh
Column A will contain Names
Column B will contain Different Amounts
I need Column C to contain the sum of Amounts for unique Names.
Some sample values are filled in Cell C( the way i require) in the attachments.
Your help in this regard will be highly appreciated.
|
Hi,
Here is one way. Put the below formula into cell C2 and copy down as needed.
=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$63,A2,B$2:B$6 3),"")