Sumif....
Thanks guys
"Bob Phillips" wrote:
You reckon?
=SUMPRODUCT(--(C27:C38<--"2006-01-04"),--(C27:C38--"2005-11-17"),D27:D38)
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Dave F" wrote in message
...
=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
|