Hi All

Secondary question could I adapt the formula
=SUMPRODUCT((C1:C36<DATE(2009,1,31))*(I1:I36="Awai ting inspection"))

to give a count using the criteria of between two dates.

Eg Count Awaiting Inspection entries if date in column B is between 1st feb
2009 and 15th Feb 2009.

Many thanx
Ajay