Table Grouping

[sathishkm]

Hi

I have table containing Names and Score like mentioned below


Name Score
Kevin Rinn 50
Paulette Campana 100
Becky Davis 30
Patty Rosely 40
Kendra Struthers 30
Mark Ohmer 20
Kevin Rinn 10
Paulette Campana 35
Becky Davis 50
Patty Rosely 25
Kendra Struthers 35
Mark Ohmer 35

I need a formula in excel to do sum all the name score like this

Name Score
Becky Davis 80
Kendra Struthers 80
Kevin Rinn 60
Mark Ohmer 55
Patty Rosely 65
Paulette Campana 135

[Ace_XL]

Use SUMIF

=SUMIF($A$1:$A$10,A1,$B$1:$B$10)

Alternatively use pivot tables..

http://office.microsoft.com/en-us/ex...001034632.aspx

[sathishkm]

Its is not so good. My Problem is different.

[vlady]

maybe with name listing ...


get total.xlsx