=SUMIF(AND(C27:C38<"1/4/2006",C27:C38"11/17/2005"),D27:D38)
--
Brevity is the soul of wit.


"Bob Barnes" wrote:

I'm an Access Programmer...

A co-worker asked why this doesn't work - it gives "0".

=SUMIF(C27:C38,"<01/04/2006 and 11/17/2005",D27:D38)

The...
"<01/04/2006 and 11/17/2005"...doesn't work

"<01/04/2006"...does work

TIA - Bob