Thanks to all of you for your quick Replies. It is now working perfectly.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(F2:F30=DATE(2007,3,24)),--(F2:F30<=DATE(2007,3,31)),--(L2:L30="Critical"))

Better to use cells to hold the criteria:

A1 = 3/24/2007
B1 = 3/31/2007
C1 = Critical

=SUMPRODUCT(--(F2:F30=A1),--(F2:F30<=B1),--(L2:L30=C1))

Biff

"Rusty" wrote in message
...
I am trying to get the total number of items that match two criteria. The
first criteria is that the date is between 24/03/2007 and including
31/03/2007 (24-31 March 2007) and the second is that the status is
Critical.

Date is in column F2 down to F30
Status is in column L2 down to L30

Column F----------Column L
Date Reported-----Status
29/03/2007--------Critical
5/03/2007----------Critical
25/03/2007---------Critical

From the above list I should get a result of 2.

Thanks