date range additions

[Ann]

if column A "text" and column A "more text" and column B date > 5/18 and less
than 5/22 (***date is the current week) then sum number in column C.

basically looking for: based what's in column A, the dates in column B
should be the current week, then add whats in column C

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(A1:A30="a"),--(B1:B30>=TODAY()-7),--(B1:B30<=TODAY()),C1:C30)



adapt to fit your data



--


Regards,


Peo Sjoblom

 

[Ann]

close...i need to put in a date, rather than -7. for example i need it to be
=SUMPRODUCT(--(A1:A30="a"),--(B1:B30>=5/18/2008),--(B1:B30<=5/22/2008),C1:C30)

what's the correct syntax for the dates?

 

[ND Pard]

In lieu of the 5/18/2008, use the Date(2008,5,18) function, etc.

Good Luck.

 

[Ann]

here's the formula i'm using.
=SUMPRODUCT(--(H3:H200="ABC"),--(D3200>DATE(2008,5,18)),--(D3200>=DATE(2008,5,22)),E3:E200)

it's only adding up if the date matches 5/22, not 5/19 through 5/22.
tia

 

[Peo Sjoblom]

You need to check the original formula I gave you and use the same
technique, the last date part should be

(D3200<=DATE(2008,5,22)

and not

(D3200>=DATE(2008,5,22)





--


Regards,


Peo Sjoblom

 

[Ann]

thank you so much, don't know when i changed it, that fixed it!