View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default summing multi entries

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

"Vtaylir" wrote:

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?