Sounds like SumProduct to me (a lot of postings on this

=sumproduct(--(leasetracker!$E$2:$E$2000="Apples"),--(leasetracker!$H$2:$H$2000="COM"),--(DateRange=firstdate),--(daterange<=seconddate))

will do it for you - obviously replace the daterange, firstdate and
seconddate with the relevent information - and it's no longer an array
function!