Sum after consideration of date ranges???

Good Morning All!!

I am working on a spreadsheet that I would like to have data in one column added and the answer to populate in another column, but the I would like the data to take into consideration a date range before populating the answer. I think I thoroughly confused the words, but see the example below for claification. Any help is greatly appreciated!!!

Column A	Column B	Column C	Blank Column	Qty for Sept	Qty for Oct
09/01/2013	Jane Doe	3		4	6
10/01/2013	John Doe	2
09/15/2013	Doe Jane	1
10/15/2013	Doe John	4

In the table above, I would like for the column labeled "Qty for Sept" to look at column A and for any dates in September, I would like it to add the numbers indicated in Column C and populate the answer under "Qty for Sept". Same for "Qty of Oct", I would like for the answer to be populated based on the dates entered in Column A that are October dates and add the numbers in Column C. I don't want to have to "sort" the spreadsheet to be able to calculate these numbers, I would prefer that it be done automatically with its current set-up. Again, any help would be greatly appreciated!!!

Mandi

It worked!!!!! Thank you sooooo much!!!!!

Mandi

...I'm gonna steal you're blank column and fill it with stuff.

D1 = Month(A1)
then pull down

Then:

Qty for Sept = SUMIF(D1:D100,9,C1:C100)
Qty for Oct = SUMIF(D1:D100,10,C1:C100)

Note that 100 should be "big enough for all the data", not necessary exactly 100.

Well, I would stick them in a table like this:

E1:E12 = 1:12 // "Month (Number)"
F1 = SUMIF($D$1:$D$100,E1,$C$1:$C$100) // sum for month at same row
//and pull down to F12

maybe stick the formula in G1:G12 and have a month label in F1:F12 for easy reading.