SUMIF formula only looking for the Month not the Days

[ryancurran22]

I use a SUMIF formula for a cash-flow to extract any payment made on a certain month to accumulate in the cashflow for that month. The problem I am having is the payment dates need to be put in at the first of each month (i.e 01/04/2014 even if it was actually paid on 14/04/14). Is there a formula that will work the same but only pick up the month rather and disregard the day rather than doing 31 SUMIF statements?

Ryan

 

[skorpionkz]

Excel 2012
	G	H
2	20/02/2014	01/02/2014
Original Data

Cell Formulas
Range	Formula
H2	=DATE(YEAR(G2),MONTH(G2),1)