Toyin,
Thanks for your response, I've got what I need now, but your solution
has some good steps for some other applications. Thanks again. Dean

" wrote:

Dean,

Assuming you are trying to sum the corresponding cells that end in
2069/15 in the first column and also have CPO in the second column you
need to do the following:

=RIGHT(TRIM(A1),7)&B1 in column (copy down)

the formula to sum the relevant cells is then

=SUMIF(D1:D4,"2069/15CPO",C1:C4)

HTH

Toyin.