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

HTH,
Paul

"Vtaylir" wrote in message
...
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?