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 sam
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,
B
--
Message posted from
http://www.ExcelForum.com