=SUMPRODUCT(--(A1:A100="John"),--(B1:B1005),B1:B100)


"Ricardo" wrote:

hi

i have a problem with the sumif. i have the following example

Col. A Col. B
John 5
Joe 10
John 6
John 7

I want to know the sum of John´s I have 5

Thanks for help. Have a great 2007.