A1:A10 contain date
in C1:C10 add following formula
=MONTH(A1)
in D1:D10 add following formula
=SUMIF(C1:C10,MONTH(TODAY()),B1:B10)

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com