Dean,

here's one way.

=SUM((B1:B4="CPO")*(IF(ISERROR(FIND("2069/15", A1:A4)), FALSE, TRUE))*C1:C4)


--
Hope that helps.

Vergel Adriano


"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