How do I map out quantities and delivery dates by style

[ShariRS]

Hi, I'm a newbie
Basically, So I don't have to key quantities into cells by month by style. Is there a formula I can use that says for example: "sum quantities of this style between June 1 2015 & June 30 2015". I know this is probably something simple yet I can't figure out the syntax.

File example attached.

Thanks so much!
Shari

[JieJenn]

Have you looked into Pivot Table? You can group Dely field by months.

[ShariRS]

"cells" ughhhh retail

[ShariRS]

Thank you so much . The pivot helps slightly however, I still need to put the quantities in the correct sells as I have lots of dates and styles.

[Czeslaw]

=sumproduct((month($c$2:$c$11)=month(1&g$1))*($a$2:$a$11=$f2)*$b$2:$b$11)

[ShariRS]

Thank you so much Czeslaw
JieJenn - Quick question. How did you get the pivot to only recognize & sum the month?