SUM of data based on names in other cell (more complicated that it sounds)

**will561** · 03-19-2014, 08:25 AM

Hello

Thank you for looking at my first post.
I have a bit of a dilema relating to summing data based on duplicates. See example of my issue below.

Name A 14
Name A 56
Name A 900 Sum of Name A
Name B 100
Name B 2 Sum of Name B
Name C 5000 Sum of Name C
Name D 10000
Name D 3000
Name D 200 Sum of Name D

I need to sum the totals of each name I have tried a few SUM IF's but to no avail unfortunatley.
Each name could come up 1-10 times which is where i am struggling. I am also trying to make the formula only sum the final instance of the name occuring.

Any help is greatly appreciated its probably a quick fix i'm just missing!

**AZ-XL** · 03-19-2014, 08:34 AM

Hi
Assuming that your data starts from a1 cell and numbers in B column. then c1 cell
=IF(COUNTIF($A$1:A1,A1)=COUNTIF(A:A,A1),SUMIF(A:A,A1,B:B),"")
then drag down