Looks like you have a third condition - column B is greater than 0.
Try this:

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

If you have other years in there, you might like to have another term
like this:

*(YEAR($C$1:$C$100)=2008)

Hope this helps.

Pete

On Feb 11, 6:01*am, Astro wrote:
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!!!