Number of Occurrences between Specidied Date
 

I hope someone can help[ me with this, I have found several solutions but
none have worked 100%

I have 2 woorksheets, one which has the data entered onto it and the
other does a summary.

The first data sheet has column A which will have dates entered from
1/1/2005 to 31/12/2005

The second column B has a type entered (6 different from a drop down box)

The second summary sheet will be used to summarise the data

Column A3 to A8 will have the 6 data types and column B2 to M2 will have
the months.

I need a formula to cont the number of occuences for each type in each
month.

I have tried

=SUMPRODUCT((Damages!A2:A151=DATE(2005,1,1))*(Dam ages!B2:B151=A2)-
SUMPRODUCT((Damages!A2:A151=DATE(2005,1,31))*(Dam ages!B2:B151=A2)))

Which works ok for january, but formula goes wrong when I change the
dates from January to February

I think I need something like this but cannot get it to work

=SUMPRODUCT((Damages!$A$2:$A$151=

Formula to either itentify month or specify dates between

*(Damages!B2:B151=A2))


Regards

Trevor