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

 

[Andrew Poulsom]

You could try:

=SUMIF(E2:E1430,"<=8/31/06",F2:F1430)-SUMIF(E2:E1430,"<8/1/06",F2:F1430)

or:

=SUMPRODUCT(--(MONTH(E2:E1430)=8),F2:F1430)

 

[srizki]

Thank you Andrew.

 

[Airfix9]

EG for August:

=SUMIF(E2:E1430,">=8/1/06",F2:F1430)-SUMIF(E2:E1430,">=9/1/06",F2:F1430)

 

[srizki]

On the other sheet I have instead of whole date there is just 01, 02, 03 etc. I am trying to put that in the second formula you provided, but I am doing it worng, can you please correct my formaul.
=SUMPRODUCT(--(F9:F4832=8),G9:G4832)
Thanks

 

[srizki]

I got it, Thank for checking it,

=SUMIF(F9:F4832,"=08",G9:G4832)