Thank you, all. Based on your suggestions, I got it to work.

"Ashish Mathur" wrote:

=SUMPRODUCT((A22:A24=A26)*(B22:B24)*(C22:C24))

A26 contains Jim

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"lisay" wrote in message
...
Help please!

I have the following data:


A B C
Jim 10 50%
Jack 10 100%
Jim 5 100%

If I'm looking for the sumproduct of col B and C, if col A = Jim. I don't
know how to do this in Excel 2003. I can do this in Excel 2007.

Any help would be much appreciated.