Hi,

Thanks for the replies - both work. I will use ACE_XL's as this includes both columns.

Does anyone know why the orgianal formula wouldn't work - I can not see why?
=SUMPRODUCT((LEFT($H$13:$H$14,4)="1104")*($J$13:$J$14="")*(LEFT($G$13:$G$14,3)=$O13)*($K$13:$K$14))+SUMPRODUCT((LEFT($H$13:$H$14,4)="1108")*($J$13:$J$14="")*(LEFT($G$13:$G$14,3)=$O13)*($K$13:$K$14))
Paul