Won't work for Scandinavian dates though, may I suggest

=SUMPRODUCT(--(A1:A6=DATE(2004,1,1)),--(A1:A6<=DATE(2004,3,31)),--(B1:B6="List"),C1:C6)

this way all the functions will be translated into local versions and work

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Domenic" wrote in message
...

Thanks Bob! I appreciate the advice! And yes, it can be confusing at
times. :)

Cheers mate!

Bob Phillips Wrote:
When embedding a date, I would suggest using

=SUMPRODUCT(--(A1:A6=--"2004/01/01"),--(A1:A6<=--"2004/03/31"),--(B1:B6="Li
st"),C1:C6)

it uses a more standard date format, and avoids any confusion with US
and
European dates.

--

HTH

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


"Domenic" wrote in message
...


=SUMPRODUCT(--(A1:A6="1/1/2004"+0),--(A1:A6<="3/31/2004"+0),--(B1:B6="List"
),C1:C6)

OR

=SUMPRODUCT(--(A1:A6=D1),--(A1:A6<=E1),--(B1:B6=F1),C1:C6)

..where D1 is the start date, E1 the end date, and F1 the "Type" of
interest.

Hope this helps!


--
Domenic

------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=276136



--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=276136