A little background...The data is in Worksheet1 and I want to show the
results in Worksheet2. Column A=Month, Column B=Date mm/dd/yyyy format. I
want to get rid of column A and just use the Date format above....Help??


SUMPRODUCT((WORKSHEET1!$A$3:$A$1000="JAN")*(WORKSH EET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$100 0)

try
SUMPRODUCT((month(WORKSHEET1!$b$3:$b$1000)=1)*(WOR KSHEET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$ 1000)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joseph" wrote in message
...
A little background...The data is in Worksheet1 and I want to show the
results in Worksheet2. Column A=Month, Column B=Date mm/dd/yyyy format.
I
want to get rid of column A and just use the Date format above....Help??


SUMPRODUCT((WORKSHEET1!$A$3:$A$1000="JAN")*(WORKSH EET1!$J$3:$J$1000="MODEL#")*WORKSHEET1!$F$3:$F$100 0)