Summing Monthly values

I have data values in a spreadsheet in columns: Date in one column, and costsin a second column. How can I add up in another column all the costs for January, for February, for March, etc.

Thanks

Assuming dates in column A (A1 to A1000, say), and costs in column B,
enter January, February, March etc to December in C1:C12. Then enter
this formula in D1:

=SUM(IF(MONTH(A$1:A$1000)=ROW(),B$1:B$1000,0))

Do not use <enter> when you have typed it in - use CTRL-SHIFT-ENTER at
the same time, and if you do it correctly then Excel will wrap curly
braces { } around the formula. Copy it down to D12.

Hope this helps.

Pete