Use cells to hold the criteria you want to count for:

D1 = 2/12/2009
E1 = D

Then:

=SUMPRODUCT(--(A1:A6=D1),--(B1:B6=E1))

--
Biff
Microsoft Excel MVP


"Jafferi" wrote in message
...
The scenario:
cell A - I have a range of date (title Date) and cell B - I have a range
of
incidents (title Error Dept)
-------
Date | Error Dept
Feb 12 D
Feb 12 O
Feb 13 D
Feb 15 O
Feb 12 D
Feb 13 O

How can I formula the results that tells me there are 2 Ds in Feb 12 from
Error Department.