Based on the following data I would like a formula in Column D that will
return a value based on data in columns a, b and c.
a b c
D
1 WC0256 ITT OPEN $500.00 Internal
2 14A555 SOLD $100.00 $100
3 WE0516 ITT PARTIAL $200.00 Internal

The Column D values are the correct value. I tried this formula but I'm not
sure what's wrong with it.

SUMPRODUCT(--( ISERR(SEARCH("ITT",b1)),--(
ISerror(LEFT(a1)+0)),(c1)),"Internal"

THANK YOU