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