Can anyone help me with this formula?
 

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

Can anyone help me with this formula?
 

So you want to use column B instead of A? And you want a count against
each month? Put your months in A2:A13 of sheet2, then put this formula
in B2:

=SUMPRODUCT(--(TEXT(WORKSHEET1!$B$3:$B$1000,"mmmm")=A2))

and then copy down to B13. This will count all models sold in January,
so if your other sheet contains data for several years it will over-
count and you will need an amendment to take acount of the year.

Hope this helps.

Pete

On Jul 31, 4:21*pm, Joseph wrote:
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$1 000)..

Any help is greatly appreciated,

Thanks,

Joseph