Need someone to examine this formula...

[soltek]

When I use those formulas, I get a 0 result, and I should have at least
100. Where does the "true" factor in? Are the dates cells in th
middle of the formula already the true part of the IF statement

 

[AK]

try sumproduct in lieu of sum

 

[AK]

oops, didnt read thru entire thread, see that you already had the sumproduct
piece,

try this:
")" is important on where you put it
=SUMPRODUCT((U9:U1002="D")*(L9:L1002>=J6)*(L9:L1002<=L6))*(I9:I1002)