Excel 2007 : Total for the current month

Hi,

I have a cell that gives the total for the current day with the formula

=SUMIF(A2:A10014,TODAY(),D2:D10014)

In the A column is the date format 08/06/2012. It works pretty good and always displays the current daily total. I have been looking however to have the cell next to it giving me the total for the whole of the current month, i.e. anything in colums A with the current month's value of June.

.....Col A....................Col D
08/06/2012..................20
09/06/2012..................52
09/06/2012..................18
12/06/2012..................10

So I want a formula that will tell me the month total of 100 from the above.

Sorry for my long winded explanation. I've never posted in a forum before.

Greg