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


--
ATK
------------------------------------------------------------------------
ATK's Profile: http://www.excelforum.com/member.php...o&userid=27662
View this thread: http://www.excelforum.com/showthread...hreadid=513390

Summing Monthly values
 

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