See http://xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation

HTH

Bob


"Johnnie" wrote in message
...
Luke
Thanks for the help. Your formula was returning a value of 0. Micky
suggested changing -- to + and it worked.

One more question, I have seen this -- on formulas I have received from
other spreadsheets. I looked it up in help and could not find out what
this
symbolizes. Can you help on this?

Once again, thanks much.
Johnnie

"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