A
Ajay
Hi All
Secondary question could I adapt the formula
=SUMPRODUCT((C1:C36<DATE(2009,1,31))*(I1:I36="Awaiting 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
Secondary question could I adapt the formula
=SUMPRODUCT((C1:C36<DATE(2009,1,31))*(I1:I36="Awaiting 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