SUMIF based on range of DATE

[srizki]

I used these formula to sum by months, but I realized that not all dates are on the first day of the month, there for it did not work.
Can some one help me by providing a formula that sums on the base of range date or rather month.
thanks.

YTD August FA and GL.xls
	D	E	F	G
1433	TotalForAugust		3,405,503.26
1434	TotalForJuly		2,945,583.84
1435	TotalForJune		6,933,994.76
1436	TotalforMay		9,996,888.58
1437	TotalforApril		11,025,035.74
1438	TotalforMarch		3,620,218.39
1439	TotalforFebruary		4,319,309.93
1440	TotalforJanuary		8,322,190.62
AUGUST YTD FA

 

[Aladin Akyurek]

E1433: 1-Aug-06

F1433:

=SUMIF($E$2:$E$1430,">="&E1433,$F$2:$F$1430)-SUMIF($E$2:$E$1430,">"&EOMONTH(E1433,0),$F$2:$F$1430)

Or:

=SUMPRODUCT(($E$2:$E$1430-DAY($E$2:$E$1430)+1=E1433)+0,$F$2:$F$1430)

 

[srizki]

Thank youi Aladin, sorry I clicked it twice, it posted twice.
Thanks again.