try the Sumproduct
=SUMPRODUCT(--(A1:A10="Susan"),--(C1:C10<DATE(2009,2,28)+7),--(B1:B10))

Change the 2nd part for the day to +6, +2 according.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis




"pgarcia" wrote:

Hello all,
I need to look up a name "Susan" in A1, sum $ in B1 but only if C1=2/28/2009
is greater then 7 days. I would need to also do the following: 7 or more days
(which is the example), 3-6 days old and 1-2 days old.

Thanks