Hi all,

I couldn't really explain what I meant in a nice catchy title! Anyway, I have this array formula (kindly put together with the help of this very forum):

=SUM(IF(ISTEXT(R6:R144),(LEFT(R6:R144,2)="HP")*(0&TRIM(MID(R6:R144,3,255)))))
This sums the values of cells in the range R6 to R144 that have the prefix HP.

eg. If there were 2 cells in this range with the HP prefix - HP 7.5 and HP 12 - the result would be 19.5, even if other cells in the range held numeric values.

This works like a charm but I now need to calculate this figure with a further criteria, that being only cells in the range R6 to R144 that have the HP prefix AND also have "ABC" in the corresponding cell in column L.

To be honest I don't fully understand the above formula, and have tried to add a further criteria but to no avail. Any help is greatfully received.

Thanks, Chris