MONTH/SUMIF Function

[bwjudy]

I have dates listed in column A in format 00/00/0000. I have costs located in column C, and would like to return sum of all costs that apply to specfic months. So if the date were 6/10/2007 and I had two others in the month of June and they each had a corresponding cost in Column C, I need the formula to return the sum off all costs in the month of June. I will have every month of the year listed, and I will be doing this for each month.

I had a formula like this, but it won't work:
"SUMIF(A:A,MONTH(6),C:C)" also
"=SUM(IF(MONTH(A:A)=6,C3,0))"

Thanks,
Judy

[NBVC]

=SUM(IF(MONTH(A1:A5)=6,C1:C5))

Adjust ranges to suit and confirm with Ctrl+Shift+Enter not just Enter.

Note: You can not use whole column references such as A:A with Array formulas such as this one.