Are these possible?
I've got the following formula to work out how many instances there are of "Apples" and "COM" occuring at the same time

{=COUNT(IF((leasetracker!$E$2:$E$2000="Apples")*(leasetracker!$H$2:$H$2000="COM"),leasetracker!$A$2:$A$20000))}

I want to work out how many times they occur between two dates. (They would be in column Z

Many Thanks