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.

 

[Paul]

SUMIF can only have one criteria, but you're looking to use two (les
than or equal, greater than). In 2007 you can use SUMIFS, but if othe
users on 2003 need to use the sheet, then try SUMPRODUCT:

=SUMPRODUCT((L6:L8>B20)*(L6:L8<=C20)*K6:K8)

 

[Roger Govier]

Hi

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