I have a speadsheet with various columns, one containing three different
product types (NEW,USED and RESUBMITTED). I need to record how many times
NEW,USED and RESUBMITTED is used for each month. I have a column further on
in the spreadsheet with dates in.
Is there a formula/function that will pick up the three product types
seperately for each month?

Example:
Product Type Date
NEW 04/01/2006
USED 12/12/2005
RESUBMITTED 19/11/2005
RESUBMITTED 27/10/2005
RESUBMITTED 04/10/2005
NEW 11/09/2006
USED 19/08/2005
NEW 04/10/2005
NEW 11/09/2006
USED 12/12/2005
USED 19/11/2005