See if anyone can help... I am trying to write a formula that-- if column B
has a specific value it will add the quanity from the corresponding block in
column D. Seems all I can end up with is a zero each time.

a b c d
1 e z f 1
2 d d z 3
3 e s e 1

if it a value in column a = e than add value of d
the answer would be 2.

thanks