Give SumProduct a try...

=SUMPRODUCT(--(ISNUMBER(FIND("2069/15", $A$1:$A$4))), --($B$1:$B$4 =
"CPO"),$C$1:$C$4)

Take a look at this for an explanation (Example 9)...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Dean" wrote:

I'm hoping someone will add to be able to show me what I'm doing wrong. I'll
try to show a simple example.
Spreadsheet view:
A B C
1 11COH1092069/15 CPO 14
2 11COH1092069/15 14
3 11COH1092069/15 CPO 14
4 11COH1092069/14 14

Formula that I would like to use:
=(SUM(B1:B4="CPO")*(A1:A4="*2069/15*")*C1:C4)
It doesn't work, any ideas? Thx - Dean