summing multi entries

[Guest]

Ok so I have a spread sheet that looks like this.

Mary 1
David 5
Paul 2
David 1
David 2
Paul 8
Josh 1

How do I get all Davids to sum together without subtotaling and screwing up
my page format?

 

[PCLIVE]

=SUMIF(A1:A10,"David",B1:B10)

HTH,
Paul

 

[Guest]

=sumif(A1:A7,"David",B1:B7)