Sumif comparing dates in criteria

[sdjsage]

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.

 

[Roger Govier]

Hi

Try
=SUMPRODUCT(($L$6:$L$8>=B20)*($L6:$L8<=C20)*K6:K8)