How to match names and add totals?

[Nikkiho]

Hi, Im sure this is a really simple solution but I can't figure it out.

I have a spreadsheet that looks like this

Column A Column B Column C Column E Column F Column G
Name # of in # of Out Name Total in Total out
Mary 1 1
John 2 1
Kathy 1 5
Mary 2 4

What I want is in Column E I want it to take the name from Column A but as you can see Mary appears twice. I only want her to appear once in column E. Then in Column F I want the total "in" so in this case Column E would say Mary, Column F would have 3 and Column G would have 5 (which is the total of all the in's and outs Mary has had)

Does that make sense?

Thanks

 

[etaf]

you could use a pivot table to do that

Book1
	A	B	C	D	E	F	G
1	Name	# of in	# of Out		Row Labels	Sum of # of in	Sum of # of Out
2	Mary	1	1		John	2	1
3	John	2	1		Kathy	1	5
4	Kathy	1	5		Mary	3	5
5	Mary	2	4		Grand Total	6	11
6
Sheet1

 

[JLGWhiz]

Or vba

Sub t()
Dim c As Range
Range("A1", Cells(Rows.Count, 1).End(xlUp)).AdvancedFilter xlFilterCopy, , Range("E1"), True
    For Each c In Range("E2", Cells(Rows.Count, 5).End(xlUp))
        c.Offset(, 1) = Application.SumIf(Range("A:A"), c.Value, Range("B:B"))
        c.Offset(, 2) = Application.SumIf(Range("A:A"), c.Value, Range("C:C"))
    Next    
End Sub