Help with SUMIF Dates

[ryancurran22]

My Formula is currently =SUMIF($F6:$F9,D77,$C6:$C9) with the column C being different purchase costs, F being the respective purchase dates, and D77 contains the month of the cash-flow for the date to flow to below.

At the moment the dates need to be on the first day of the month to flow to the cash-flow but I need to enter exact dates but when I do this the current formula doesn't drag it into the cash-flow.
Basically I think i need a formula that disregards the day and only account for the month and year so no matter what the day in the date is, it will drag it into that months cash-flow.

Thanks

Ryan

 

[FormR]

One option if you have XL2007 or higher:

=SUMIFS(C6:C9,F6:F9,">="&D77,F6:F9,"<="&EOMONTH(D77,0))

EDIT:

Another option that will work with all versions:

=SUMPRODUCT(--(TEXT(F6:F9,"YYYYMM")=TEXT(D77,"YYYYMM")),C6:C9)