| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif....
You're welcome!
Biff "Bob Barnes" wrote in message ... Another - thank you. "T. Valko" wrote: Try this: =SUMIF(C27:C38,"2005/11/17",D27:D38)-SUMIF(C27:C38,"=2006/1/4",D27:D38) Better to use cells to hold the date variables: A27 = 11/17/2005 A28 = 1/4/2006 =SUMIF(C27:C38,""&A27,D27:D38)-SUMIF(C27:C38,"="&A28,D27:D38) Biff "Bob Barnes" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
| Help with SUMIF function | Excel Worksheet Functions | |||
| Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
| SUMIF | Excel Worksheet Functions | |||
Threaded Mode
