Thanks Mickie, the plus sign did the trick.

"מיכאל (מיקי) אבידן" wrote:

Didn't you mean:
=SUMPRODUCT((A2:A7="Carrie David")+(A2:A7="David David")+(A2:A7="Katy
David"),B2:B7)
Micky


"Luke M" wrote:

=SUMPRODUCT(--(A2:A7="Carrie David"),--(A2:A7="David David"),--(A2:A7="Katy
David"),B2:B7)


Note, if you had a list of names you wanted to include in Column C, you
could do this instead:
=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A7,C:C,0))),B2:B7)
which would give you more flexibility for changes.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Johnnie" wrote:

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