I want to count the number of cells in column B, where two criteria is true.

I.e. i want to count the number of cells in column B that equal 01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006

Thanks

Andy