Sumif....
Thanks guys...
"Ron Coderre" wrote:
Try one of these:
=SUMIF(C27:C38,"11/17/2005",D27:D38)-SUMIF(C27:C38,"=1/4/2006",D27:D38)
or...a bit shorter (and a bit less intuitive)
=SUM(SUMIF(C27:C38,{"11/17/2005","=1/4/2006"},D27:D38)*{1,-1})
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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
|