A little background first, ....I'm trying to add different models sold in a
month...The spreadsheet covers all 12 months....I entered items sold in
Worksheet1 and I want the results to appear on Worksheet2..

Headings currently using a A=Month, B=Date of sale, C=Customer's name etc..
I would like to see if I can use the date of sale to calculate the models#
sold in a month..

This is what I currently use:
SUMPRODUCT((WORKSHEET1!$A$:$A$1000="MONTH")*(WORKS HEET1!$j$3:$j$1000="MODEL#")*WORKSHEET1!$F$3:$F$10 00)..

Any help is greatly appreciated,

Thanks,

Joseph