I like to use:

date(2005,1,1)
(It's unambiguous)

Then I don't have to worry about datevalue() returning an incorrect date.

does
=datevalue("01/02/2005")
refer to Jan 2nd, 2005 or Feb 1st, 2005?

ram wrote:

I had to use date value and it works great

Range("B27").Value =
Evaluate("=SUMPRODUCT((Active!a1:a24=Datevalue(""0 1/01/2005""))*(Active!C1:C24=614546),Active!K1:K24)")

Thanks for all the help guys

"Bob Phillips" wrote:

That sounds that you don't have a worksheet called ACTIVE

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ram" wrote in message
...
Hi Bob,

When I used your code i recevied the #REF! error. Any suggestions?


Thanks again


"Bob Phillips" wrote:

Try

Range("B27").Value =
Evaluate("=SUMPRODUCT((ACTIVE!A1:A24=--""2005-01-01"")*" & _
"(ACTIVE!C1:C24=614546)*ACTIVE!D1:D24)")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ram" wrote in message
...
When I use the code below I receive the #value! error message. Can
someone
explain what i'm doing wrong?

Range("b27") = Evaluate("=sumproduct((active!A1:A24
=01/01/2005)*(ACTIVE!C1:C24=614546)*ACTIVE!D1:D24))")


Thanks for your time and help







--

Dave Peterson