thanks for all of you ....
I think it will solve my problem.

"bcmiller " wrote in message
...
say sheet1.a1 = "Blah"

sheet2.column a & b =
blah 5
eggs 7
yo 9
blah 3
fish 5
drink 7

the formula would be
=sum(if(sheet2!a1:a6=sheet1!a1, sheet2!b1:b7,0))

after you've type this formula press cntrl + shft + enter at the same
time. if you don't the formula will be an error.

the final formula should look like

{=sum(if(sheet2!a1:a6=sheet1!a1, sheet2!b1:b7,0))}

Cheers,

BC


---
Message posted from http://www.ExcelForum.com/