Summing Monthly values

A

ATK

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
 
P

Pete_UK

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
 
Top