sumif date is in certain month
 

I need to sum currency when the corresponding date is in a certain month. I
can not figure out the formula. For example:
SUMIF(D2:D20,"5/31/05, <6/30/05",C2:C20)
When the date in D is in the month of June, add the amount in C. I think
the problem is in the calculation of the month. I have tried every thing I
can think of, including using the (=MONTH).

one way:

=SUMIF(D2:D20,"5/31/05",C2:C20) - SUMIF(D2:D20,"=6/30/05",C2:C20)

Another:

=SUMPRODUCT(--(D2:D20DATE(2005,5,31)),--(D2:D20<DATE(2005,6,30)),
C2:C20)




In article ,
AKM wrote:

I need to sum currency when the corresponding date is in a certain month. I
can not figure out the formula. For example:
SUMIF(D2:D20,"5/31/05, <6/30/05",C2:C20)
When the date in D is in the month of June, add the amount in C. I think
the problem is in the calculation of the month. I have tried every thing I
can think of, including using the (=MONTH).