Traverse a colum match a text and return sum of all values in adjacent cells

**realdost** · 05-22-2012, 06:41 PM

Hi
I am a new learner for excel and trying to solve following problem. Please help
I have a table of format given below:

A (name) B ($)
Jay 10
Kay 20
Nay 30
Jay 40
Kay 50
Pay 60

I need to do find create another table showing how much total Jay , kay, nay, Pay ows ? For eg here Jay ows 50 (10+40) kay 70 (20+50) and so on.

Any Help would be highly appreciated.

Thanks

**Sa DQ** · 05-22-2012, 10:03 PM

PHP Code:


Sub GPE_COM()
 Dim Rng As Range, Rws As Long
 
 Set Rng = [A1].CurrentRegion:        Rws = Rng.Rows.Count
 Rng(1).Resize(Rws).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("D1"), Unique:=True
 [E1].FormulaR1C1 = "=RC[-3]"
 [E2].FormulaR1C1 = "=SUMIF(r" & 1 & "C[-4]:R[" & Rws & "]C[-3],RC[-1],R" & 1 & "C[-3])"
 [E2].AutoFill Destination:=Range("E2:E" & Rws - 2), Type:=xlFillDefault
 
End Sub

**realdost** · 05-23-2012, 01:28 PM

Thanks for replying Sa DQ.
I tried your macro but i did not get any output. Not sure what is missing.
It seems the macro runs without error but I do not see any values in column C and D. I am attaching my sheet also for reference