Use
=SUMPRODUCT(--(A1:A100="Susan"),--(C1:C100="2/28/2009"),(B1:B100))
or
=SUMPRODUCT(--(A1:A100="Susan"),--(C1:C100=Today()),(B1:B100))

Change 100 to your last row

You can add other conditions by adding terms like
--(C1:C100"2/28/2009")
--(C1:C100<"2/28/2009")
--(C1:C100=(Today()+7)

"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