Hi All,

This isn't working.

=IF(AND($B$5:$B$5939721,$B$5:$B$59<39813),SUMIF($ D$5:$D$59,$C69,$F
$5:$F$59))

entered with Ctrl-Shft-Enter.

I'm trying to the a total amount in the range F5 to F59 if the date in
B5 to B59 (corresponding the number in F5 to F59 is between 39721 and
39813 and the text in D5 to D59 matches C69.

Any help would be appreciated.

Thanks,

Michele