sumif date is in certain month

[AKM]

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).

[JE McGimpsey]

one way:

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

Another:

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




In article <[email protected]>,
AKM <[email protected]> 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).