Hi Astro

=SUMPRODUCT(($A$1:$A$100="Part A")*(MONTH($B$1:$B$100)=1))

Better to put the Month number ( 1 for Jan, 2 for Feb etc. ) in a cell, also
the part number in a cell
then
=SUMPRODUCT(($A$1:$A$100=$D$1)*(MONTH($B$1:$B$100) =$E$1))

I make the count 4 for your sample data - not 2


--
Regards
Roger Govier

"Astro" wrote in message
...
Dear all,
Help is needed!!! Currently I have a excel spreadsheet showing the
following:

Part A 1 15-Jan-08
Part B 1 15-Jan-08
Part B 1 7-Jan-08
Part A 1 7-Jan-08
Part A 0 7-Jan-08
Part A 0 7-Jan-08
Part B 1 7-Jan-08
Part A 1 7-Feb-08
Part A 1 7-Feb-08

What formula can I use in order to generate a report to show that the
count
for Part A is "2" under the month Jan 08 shown below:

Jan 08' Feb
Part A 2 2
Part B 3 0

Please help...... Thanks!!!