An Array formula IF's , AND's

[ppneeb]

I've tried everything I can thing of to write these formulas but haven't found a way to make them work. I need a formula for the following problem(s)

Column A Quantity, Column B Description (alpha), Column C Date. Values in the date column range between 1/1/12 and 12/31/17. Approx 100 rows ( number of rows will vary)
Rows stay sorted by Description.

Formula 1- find all dates >= 1/1/12 and <=12/31/12 then sum the quantity in the corresponding rows.
Formula 2 find all dates >= 1/1/13 and <= 12/31/13 then sum the quantity in the corresponding rows.
Formulas 3-6 same as above with only the dates changing.

[BenMiller]

With dates in column C and quantities in column A, put your start date in D1 and your end date in D2 and try:

=SUMPRODUCT(--(C1:C100>=D1)*(C1:C100<=D2),A1:A100)