Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif comparing dates in criteria
I'm trying to use SUMIF
=SUMIF(L6:L8,"=and(B20,<=C20)",K6:K8) where column L has dates in it, column K has dollar amounts and the criteria is looking at a fields that have dates. So, trying to include in the sum the payment amount if the estimated payment date is greater than last week's date but less then the current week's date. Working on a cash flow tool that would read from a list of all of our contracts entered and their estimated payment dates. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif comparing dates in criteria
Hi
Try =SUMPRODUCT(($L$6:$L$8=B20)*($L6:$L8<=C20)*K6:K8) -- Regards Roger Govier sdjsage wrote: I'm trying to use SUMIF =SUMIF(L6:L8,"=and(B20,<=C20)",K6:K8) where column L has dates in it, column K has dollar amounts and the criteria is looking at a fields that have dates. So, trying to include in the sum the payment amount if the estimated payment date is greater than last week's date but less then the current week's date. Working on a cash flow tool that would read from a list of all of our contracts entered and their estimated payment dates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif criteria between two dates | Excel Worksheet Functions | |||
Help with SUMIF using a range of dates as criteria | Excel Discussion (Misc queries) | |||
Sumif between 2 dates and specify criteria | Excel Discussion (Misc queries) | |||
SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions |