Use

=SUM(SUMIF(A2:A7,{"Carrie David","David David","Katy David"},B2:B7))

HTH

Bob


"Johnnie" wrote in message
...
I have the following information:

a b
2 Carrie David 42.50
3 Chris David 63.00
4 David David 47.75
5 John David 36.00
6 Katy David 41.25
7 Mike David 40.00

In Call b9 I would like to sum b2:b7 if a2:a7 = Carrie David or David
David
or Katy David.

Please help. Thanks
Johnnie