Hi,

Here's a starting point:

=SUMPRODUCT(--(MONTH(A2:A7)=D1),--(B2:B7=E1))

Where you have entered 2 in D1 and D in E1.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jafferi" wrote:

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.