One way

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



adapt to fit your data



--


Regards,


Peo Sjoblom


"Ann" wrote in message
...
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