Hi,

Your question doesn't make sense - C1 = 2/28/2009 is greater than 7? what
does that mean? In Excel every date after 1/7/1900 is greater than 7!

If you are asking to count or sum the number of items in column C which are
more than 7 days old relative to TODAY then there are your formulas:

SUM:
=SUMPRODUCT(--(A1:A16="Susan"),--(TODAY()-C1:C167),B1:B16)

COUNT:
=SUMPRODUCT(--(A1:A16="Susan"),--(TODAY()-C1:C167))

You may choose to modify the 7 portion depending on whether you include
today in your definition of one day gone.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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