Rusty, in an empty column, write an IF equation that uses AND(test, test,
test). For example:

=IF(AND(F3=DATEVALUE("24/3/2007"),
F3<=DATEVALUE("31/3/2007"),L3="critical"),1,0)

This returns 1 if your conditions are met, 0 if not. Then just sum that
column

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


=if(AND(F2=
"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