SUMPRODUCT OR SUMIF? with <= and >=

[LavaDude]

Hi All!

I'm pretty sure this is one of the formulas I need, but not sure how to
implement it... Here's what I have:

Column G (G4:G80) Numbers
Column I (I4:I80) Dates

Column L & M have dates as follows:

L9 6/2005 M9 12/2005
L10 1/2006 M10 12/2006

and so forth...

I need a formula that will return the following: "If (I4:I80) is greater
than or equal to (L9) AND less than or equal to (M9), then return the sum
of the values in (G4:G80)"

I've used SUMPRODUCT and SUMIF in the past, but not with "greater than/less
than" criteria ...

Can somebody please help?

Thanks in advance!!!

LavaDude...

 

[LavaDude]

I think I figured it out...

=SUMPRODUCT(--(J4:J80>=L9),--(J4:J80<=M9),H4:H80)