Count if with conditions...

Hi Richard,
Whoa! Thanks a lot.
I just realised there are a few conditions to be met before the test can be scheduled.
1. The material type, L1, must either be a standard or an elite model.
2. If the service term (I1) is a TYP A, then the service finish date (K1) must be in the future
3. If the service term (I1) is a TYP B, then the surety end date (H1) must be in the future.
How can these conditions be incorporated before counting using the earlier test conditions?
I have included some fields till row 546 in the attached data
Is there a reason why we have 0.5, pls refer to X151:X166?
Thanks a lot for your help Richard.. and I look forward to hearing from you soonest
And yes please explain how you used the array formulas