Hi,

Where did you get Excel 2009? Are you testing beta of the next version?
The is an Excel 2008 for the Mac but the latest version for the PC is 2007.
In all versions, Excel 2009 excluded, SUMPRODUCT works in the same way. If
it is returning 0 and you are using the formulas I submitted, then it
suggests that the dates may not be legal Excel dates they may be text entries
for example.

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

Cheers,
Shane Devenshire


"pgarcia" wrote:

I'm getting 0. Any thoughts? I'm using Excel 2009. I have notice what
SUMPRODUCT does not work as it should in older versions.

"Sheeloo" wrote:

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