Roy,

Just a side thought .. Maybe there are "invisible" whitespaces within the
data in col S preventing the correct pick up of the phrase "Repair Clin".

We could try using TRIM in the criteria col T to make it more robust:

In sheet: Overall

Put instead in T2, and copy down:
=IF(O2="","",IF(AND(TRIM(B2)<"Closed",TRIM(S2)<" Repair Clin"),
O2+ROW()/10^10,""))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--